Search results

are you saying instead of using a simple query designed in access use a SELECT DISTINCT. P.S. Have you had or heard of this problem before. Thanks, JOe K.

I have an expenditure summary report based off of a query. The header is displayed once my problem is that the details section (which is just a bunch of totals or Sum()'s) is displayed twice. I have checked the query and all of the correct information is there. The totals match up. The only...

I figured it out. So I'm posting my solution. In my VBA code I used DoCmd.RunCommand (acCmdSaveRecord) after update. It got rid of my error message.

Here is an example DB of what the problem is exactly. If you change the Vendor in the Combo box next to the date, it will change as it's supposed to. If you then change it again you will get the runtime error 3331. However, if you press shift-enter (saving the record) before changing the...

I'm having the same problem. Does anyone have a resolution to this issue? Thanks, JOe K.

One broken keyboard, 2 anger managment classes and numerous career re-evaluations later, I figured it out. The sum([TotalReported]) was figured out after the creation of the report, therefore having the macro run On Open of the report was creating the error because sum wasn't created yet. I...

I have a report that shows you a sum of the expenses for all of our jobs =Sum([TotalReported]). On a form prior to opening this report we have totals that we have to report to the state =[Forms]![MonthlyFinancialQueriesForm]![Total Checker]. I then have a Variance text box [Total...

I got it to work using the monthname() function. Look it up on the help file it work like a dream for me.

Thank you so much. It work great. Sorry about the duplicate post. Thanks again, JOe K.

I have a form that asks what month you completed a file (04, is april ect.). From this form a report is opened, in my report, I have it read this number and I want to display the month for the number thats entered (if they enter 04 I want april displayed on the report). There is already a ton...

I have a form that asks what month you completed a file (04, is april ect.). In my report I have it read this number and I want it to display the month for the number thats entered (if they enter 04 I want april displayed on the report). There is already a ton of data that has the...

Is there a resolution to this problem?

Is there any place in Access 2003 where I can look to see where shortcut keys (including internally set ones for office) are assigned. The crtl + ' does not duplicate records in datasheet view from the line above, on one of my employees computers. Has anyone ran in to this or have any...

I tried the DLookup and still wasn't able to get it to work perhaps I did that wrong. Here is a copy of my database. Again I need the address to correspond to the selected vendor.

I have a combo box where I select a Hardware store. I want the address for the store to come up if a hardware store is selected. If one is not selected I want to be able to enter an address. I have a vendor (hardware store) table, which contains the Hardware store and it's address. I can...

Is it possible to open up excel files from access using a macro?? I have a database where we search for files by job number, we also have individual spreadsheets for these jobs where the job number is the file name. So basically what I want to do is open one of these spreadsheets from a...

My master for the form is a Van # (primary key), in the subform I want to show all the maintanance done for that van. For some reason I keep getting that error message when I try to link the child and master fields.

yes, in design view right click the box and scroll down to, change to, then list box.

I have a form that has a subform in it. I want the key field in the form to dictate what fields show up on the subform. When I try to set the Link child and master fields, I get a 'can't build a link between unbound forms'. How do I make this subform bound to the form???? Thanks, JOe

I have a list of Vehicles in which each have their own maintanance schedules. Most of the maintanance for the Vehicles overlap. Instead of entering the same information over and over I'm assigning each type of vehicle a code number (example '05 Cargo is a 1, '04 Cargo is a 2). Now what I want...