Recent content by KeithB13

Hello, I am having trouble with a list/combo box on one of my forms. The form is running from a table that has multiple key fields(three to be exact). Anyway, when I use a list box or combo box for a seach, it always brings up the first record with matching criteria for one field only. I...

Hello all, I have a form named "Main_form" and in the form properties I have set the "Allow Edits" and "Allow Deletions" to no. I have a command button that calls a Macro named "MainForm_Macro.edit". In the macro I have tried to set the value "Allow Edits" to yes on the form. (Access 97) In...

Thank you very much, The problem was in the sorting and grouping in the main report, not the subreprot. Your tip put me on the right track. Thanks again, Keith Bledsoe

Hello all, I am having a problem with a report and I have exhausted my resources. I have a report that I am running that uses a text box value in a 'where' statement created from a macro. ""[PIR_number]=[Forms]![PIRMain_form]![PIR_Number]"" The report contains a sub-report that brings up...

Worked like a charm. Thanks for the help.

Hello all, I need to create a report that lists employees and hours they work for the week. I need to create a query that will tell a user how much time they have worked so far this week (starting monday). I don't know how to query my date field to only display the current weeks hours...

IMO, Worked like a charm. Thanks for the help. Keith

I have a combo box in a form. I would like to have the list in alphabetical order. The data in the combo box comes from a table. I have tried arraning the table but it doesn't have any effect on the order in the combo box. Could anyone please tell me how to bring order to my combo box...

I am holding the pictures in an excel files because I have serveal pictures per unit. Example... We evaluate engines and transaxles. Depending on the case we may have 2 pictures of an engine or 25 pictures of an engine. I have found it easier to put 25 pictures in to a document than to have...

Fumbuzled???? Hello all and please help, I really don't know how to explain this, so here it goes. I have a database set up that I would like to have excel spreadsheets displayed onto a form in access. The spread sheets contain pictures of engines. I have multiple exel files that contain...

Set up a query with the feild(s) you want to count and set the "total" property to "Count". You may have to use the "total: property to "group by". Set up a report based on the query. I hope this is some help. We were all wet behind the ears at some point. School Project?

Try looking at the "DateDiff" funciton in the help menu. I think you will find what you are looking for. Good luck, Keith

More help? I tried the code that was suggested. I inserted a text box into my report, I get "#error" where the total is supposed to appear. The control source is "=count([SN]). Running sum = "overall". Any ideas? Keith

Another angle...Try combining all 4 quries into one query..ie..query your querries. Use the new query in your report. Good Luck, Keith

Hello all, I am having a bit of trouble. I have several databases that I use and I just set a password for database a. Database b uses a macro to access information in one of database a's tables. What is the command that I need to add to the macro in database b to access information in...