Recent content by pat731

Thank you for any support on this matter but I figured it out myself and if anyone ever has this problem please feel free to email me directly.

That is what I am trying to figure out how to look at the export spec the action arguments say Transfer type: EXPORT FIXED WIDTH Specification Name: Site Export Specification table name qryExtractSite The specification name is in the drop box...do you know where i can see that or what esle I...

I need to make changes to a database that a person is no longer with our company and I don't know how to add a field and change the macro to export to txt. I have to add a field to the table that is 2 digits. I updated all the queries and when I run the macro it doesn't show the field I added...

I have recently upgraded to Access 2003 operating system XP, and since then my DATABASE I built will not let me produce new reports and save them. I am able to add to tables and make new queries but not reports. Any ideas what to do about this? thanks

I built a database using ACCESS 2000 with XP Operating system and recently switched to Access 2003. When I tried to change a report it wouldn't let me save the new report? Any ideas?

Thanks Chris but it didn't work - I don't know what the issue is.

Thank you I will try it again in the morning but I believe we tryed that but I will try again. Patty

Wow I am sorry about the way I worded that thread. Operating system is XP SAS is 9.1 We just had the software loaded and all the old files are still on the computer but when we try to open an old file it doen't give us an extension to open, so if we try to OPEN WITH sas isn't one of the options...

I need to know how to add the open with list for my new 9.1 Program. Can anyone point me in the right direction

Beltic, I am trying to connect an Access datafile to Visio and when I try to use the Database wizard it stops me at the part that asks for the stencil! I am using visio 2000 and access xp if that helps.

I think I found a solution to this question. Instead of using a combo box use a regular text box - and instead of using a control button to select new record I used duplicate record and it keeps the cost center and the date and all the end user has to do is key in the other fields until he wants...

In answer to your questions.... First, I didn't realize that it was posted in the Office rather than ACCESS, thanks for the idea. What version are you using - XP Does your form have tabs - page tabs? NO PAGE TABS Does your form have subforms? NO SUBFORMS How did you create the data for the...

I have created a form for inputting data and I created a Combo box with the cost numbers for the departments. The end user sometimes has multiply forms to input into to form for the same cost number But when he clicks on the control to ADD NEW RECORD he has to select the cost number again and...

How can I set up a combo box in access to stay on the selected label/field until I am ready to change the label?

Thanks Blorf but I have a month Query but now I want to make that a report based on the parameters of MONTH, YEAR.