sorry, i have created a query builder in the form linking the tables "Data Names & Structure Data" in a relationship join. I have selected the join to "only include rows where the joined field from both tables are equal." So, how do i update the textboxes on my form?
again Thanks.
I have a pull down combo box in my form. when i select an item on the list of the combo box (from table called "Query builder-Structural Names", it display imperial names and metric names), i like it to retrieve all data for that particular item that's selected from the combo box list.
All the...
Thanks Pete but it isn't exactly what i am looking for, sorry for not being more specific. I don't quite not how to explain it. You see i have a table called "CurrentTimeSheet" and in its fields are the following heading TDate,Employee,JobNo,Description,TypeTime(Regular/OverTime/Sick/Vacation...
Hi all,
I am trying to create a summary within a single report. I am taking Job Numbers (Various) breaking it up into dividual job and showing its total hour (Regular Hours and Overtime in different column table) within a date range of 2 weeks. (All this Information is on one table.)
example...
Thanks alot for your help everyone and thanks for the answer Alec! I was banging my head for awhile on this. Your answer now clears my combobox and my brain.
Shaun
Hi guys, thanks for the replies,
Yes, this is Access. I am not an expert programmer so I have kinda improvised what I am trying to accomplish. Dont laugh to hard, as I am kinda new to Access.
This will be input for a mailing label report.
I have a form that has customer address info on it. I...
Hi there,
I am trying to clear a combobox that I have loaded at the beginning of my form. My combo box consists of various items from a table. I am able to load my info into the combo box, no problem.
When the user clicks on a button, I am trying to clear the combo box, but for some reason I...
Geez, sorry, I thought I was in the Access VB forum! This is an acual Access form, not a userform from VB. I have used the .clear before in VB and it has worked but I cannot get it to work here.
Any ideas at all? Thanks for all your help!
Yes, this is crazy. I just started a brand new db and placed a combobox on a form. The combobox is called cmbTest and I placed this code in the form load event:
cmbTest.AddItem "T"
cmbTest.AddItem "D"
Now I added a button and called it cmdTest. I placed this code in the...
Hi Skip,
I have that in my third last thread line....believe it or not, it is not working and that is what I cannot understand. The error that comes up is:
Compile error:
Method or data member not found
Any reasons as to why this isn't working?
Hi there,
I am trying to clear a combobox that I have loaded at the beginning of my form. My combo box consists of various items from a table. I am able to load my info into the combo box, no problem.
When the user clicks on a button, I am trying to clear the combo box, but for some reason I...
Yes, sorry for my incorrect usage of the image control lingo. I was able to place the image control in each tab. My problem ended up being out of memory problems. It seems weird, I only have about 10 controls on a tab, and I have about 26 tabs. When I try to edit any of the properties, the...
Hi guys,
CosmoKramer, your code is fabulous! I should of thought of that myself! Thank you very much. I have programed a bit but I am totally new to access and I have thrown myself in head first! That is exactly what I needed.
Thanks again!
Funnyguy
Thanks for the replys!
Dan, I have the total working...that works great now, but it is not really the expected total I was anticipating! When I set the running sum property = overall, it ends up totaling every line previous for me. eg:
line 1 2*2*2 = 8
line 2 2*2*2 = 16
line 3 nil*nil*nil=16...
Hi,
I am new to Access and I am trying to create something very simple but because I am stupid, I am having trouble. What I am doing is creating a textbox with an expression in a calculated control source on a report. This is how it reads:
= a * b * c (These are all fields in a table)
Now all...
never put a box online without checking updates from the vendor, in this case, ftp://updates.redhat.com/ . subscribe to advisory lists, if an exploit comes out, a vendor will normally patch that week or next, just disable the service till then.
I have this machine, where basic functionality of the box seems damaged. It's a semi-fresh install yet, I closed a lot of services, ones whos description seemed unused to me.The machines complains about a service not starting at boot time, but I can't really view the Event Log, because...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.