Search results

I have the following in my criteria and it does not not show any records when I leave the combo field blank. What am I doing wrong? [Forms]![ScaleLogSpreadsheet]![ComboName] or IsNull([Forms]![ScaleLogSpreadsheet]![ComboName]) Thanks.

I have a query with criteria captured from two fields in a form. For example: [Forms]![ScaleLogSpreadsheet]![ComboName] [Forms]![ScaleLogSpreadsheet]![ComboBatch] How do I get the criteria to work so that it shows all records if both fields are blank and also works if one of the fields is...

I have a couple questions. How do I calculate the total of a field on a form? I also want the total to show up on a page footer on a report. Should I calculate this in a quey? Also, I have a button on a subform that opens another form. This form is based on a query that has a filter based...

I have a table with vendor number and customer name. I then have another table that lists the vendor number and all of the customer's contract numbers. I also have a year column added to the table so that I can query out only the contracts for a certain year. The problem is that I need to...

I have a calculated field in a report. The value shows up in the report as #Error until I enter the values in the other cells for the calculation. Is there any was to prevent this #Error message to show up? Thanks

That worked!! Thanks! I can't believe that it is such a long formula!

I do not want it to divide by 4 if there is only data in 3 columns. There is an average function in Excel that does this. I was wondering if there is a similiar function in Access that I can use for the query.

I have a query where I want to average columns 1, 2, 3, and 4. I want the average to show up in column 5. There may not always be values in all of the columns so I cannot just divide by 4. How do I set up this formula? Thanks for the help!

I am still getting the same error message as above. When I spit the database, I get a back end file that just contains the tables. A front end table is not created. The original file just remains with all of the forms, tables, and queries. How do I create the front end? Thanks in advance...

Has anyone gotten this error message? How do I get around it so that I can create a back end? Thanks for the help!

I get the following error message when I try and use the database splitter. "subscript out of range" Does anyone know what the problem is and what I need to do to fix it? Thanks.

Where do I find the cbo properties. Also, how do I connect this to the form? Thanks.

I have an unbound combo box with last name and first name. When I click on a name I want it to open a form with the employees information. I want the form to open up by the employee ID number. Otherwise if there are two employees with the same last name the correct one will not come up. I do...

I created a pivot table by using the form wizard. I cannot figure out how to get the form to refresh every time I open it. When I click the edit pivot table button, I then go into excel but I still cannot get it to refresh on open. I have checked the refresh on open check box in Excel, but it...

Mile-O-Phile: Thanks for the post. The module that you attached is finding the right file path. The problem that I am having is how do I get this code to look up the module into a macro. I have set up a "transferSpreadsheet" macro. I need the file path that the module looks up to show in...

I am having trouble formating a field in a form. The field is from a query. The field has a percent format with no decimal places. The table has the same format. When I type in 14 the field in the form changes to 1400%. What do I need to change so that it reads 14%. Thanks in advance for...

I am trying to export a query into excel. There are multiple users so I need a place where the file can be stored. I would like for it to save on their desktop or else prompt the user for a file path. I cannot get the module to work. I copied the VBA code that Mile O Phile posted directly...

Mile-O-Phile: Do you know what I am doing wrong. I copied the code that you posted directly into a module. I then added the VBA code as an event procedure "on click". Thanks in advance for your help.

Does anyone know why this is not working?

I added the module and then I wrote the VBA code to replace the macro. When I click the button, I get the error message Complie Error: Type Mismatch The & before GetUserName is highlighted. What am I doing wrong?