Recent content by FunnyGuy

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...

My code is stopping at the .Clear method and giving me the same error still. I am baffed! I must have something wrong somewhere....

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 there! For some reason I cannot place an image box in a tab control. Does anyone know a workaround for this? Thanks!

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