Search results

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

Try moving your key field to another key field. Any unique feild will work. If you don't have one try using the Date() function instead of autonumber... I have had set up an automatic date field to record the exact time the user started entering the record. Good luck, Keith

Hello all, I have a list of serial numbers in a report. They are listed in rows of 6 per page and there are two pages worth. I would like to list the total number of objects on the list after the last serial number. I know the answer lies somewhere in the group footer, but I can't seem to...

Have you tried using the "datepart" function? You may have to query a query to get what you need. First, set up a querry to use the "datepart" function to get the week number out your date feild into a week number feild. Do the same for your year. In the second query, group your week and year...

Hello all, I have a group of reports that I would like to insert pictures into. Each reprot has a different serial number and a group of corresponding pictures. The pics are in .jpeg format. How do I set up a report that will show corresponding pictures? An example of a serial number is...

Thank you Pat, Thanks for the wonderful help. It works just like I knew it would. I think that is the one place that I didn't look for that option. Thanks again, Keith :D