Search results

Thanks for the help on the query. I am having a problem with the transfer spreadsheet macro. I have multiple users so we cannot all save to the same place. For example, I want it to save to C:\Documents and Settings\bsdixon\Desktop bsdixon is my user ID so this would change for each user...

Thanks for the help Pat. That worked great! Now the only problem that I am having is setting the number format and decimal places. Can this be done in a query? I tried to do this in my form, but it does not change the number format when I change the setting. I am not for sure why this is...

HELP!! I am having yet other problem with the query. I have a button that I want to be able to click that exports the entire form to excel. I used an "OutputTo" macro. When I click on the button, I get the error "Microsoft Access can't start the OLE server". I do not get this error when I...

I have another problem with my calculation. When I export the form to excel, the caculated values show up as different numbers. In one column I get the error message #Name? What is causing the error message and how do I get the correct values to export to excel? Thanks for your help.

Thanks for the help. On my first try I did use the brackets and it did not work so I tried the quotation marks. The second time I tried the brackets it worked. The only problem that I am having now is setting the number format and decimal places. Can this be done in a query? I tried to do...

Thanks for the response. The data will now be entered in the form instead of the query. I cannot get the update query to work. In the design view of my query, i selected update query. I then put update to No in the yes/no column. When I ran the query, only this column shows up. All of the...

I want to keep the null values so I tried your null function that you posted. Unfortunately, this function does not take into account the values that have been entered. The function gave a result of zero. Here is what I have in the field box. Total: Nz("Field 1",0)+Nz("Field 2",0)+Nz("Field...

I have a query that has a yes/no check box. I want the yes/no boxes to reset to "no" each time I open the query. I am opening the query with a click button on a form. Once the query opens I then want to select which records I need. Is there a code that will either clear the boxes or reset...

I am trying to add a formula to my query that adds three fields together. In my query I entered a new column and put SUM:[Field1]+[Field2]+[Field3] I have already entered in a lot of the data and some of the fields are blank. The formula will not work unless there are zero's in these fields...

Is this possible or do I just need to better explain what I am trying to do??? Please help!! Thanks

I have several Word documents that I would like to use as a report. So far I have opened a report in design view and then I copy and pasted the Word document into the report. I cannot figure how to insert the information that I want pulled from the database into the report. When I insert a...

Can someone please help! I cannot get the code to work so that it will populate into a new record on the second subform. Thanks!

Problem Solved. Sorry for the confusion.

I am trying to use this code to open a form. It seems to be working but instead of opening the report it prints it. What am I doing wrong?

I have a form that has customer information and their customer number. I then have a subform that has a drop down field that lists all of the product numbers that they have previously ordered. I want to select the product number from the drop down field and then have this number automatically...

I am trying to set up the relationships for the tables in my database. I have two tables that have a one to many relationship. When I try to enforce referential integrity I get an error message that says there are records that are not in my primary table. Is there anyway to quickly find these...

I was wondering if someone could help me eliminate duplicate reports. I have a report with a subreport. The main report has customer number and their address and phone numbers. The subform is related to the main form by the customer number. In the subform it then has their order number...

I am trying to add maps to some of my forms. Would it be best to link the file instead of inserting the file into the database?

I am trying to insert scanned images into my form. I was wondering what file format you would recommend that I insert these into Access. Also, the graphic is a lot less clear on the from then the image is that I scanned. Is ther anyway to improve the clarity of the object in the form? Thanks...

I thought that it might help if I were more specific. I am trying to create a form that has site location for a farmstead. This form has directions and other information about the site. I then want to create a subform that lists the various grain bins at the site and their information. For...