Search results

Thanks for your help

The third party table does have it's own Unique ID field. So I look for the ones that don't exist in the master and add them. I did get the append query to work. I had a field that was set as an number in the Master and same field was text in the Third Party. I set the thirdparty.field to...

I'm struggling with that as well. What I got is the db master customer table. I then get a table sent to me by a third party. Most of those records I have already captured in my master but there are new records that I need to bring over. When it gets brought over and inserted in the master table...

I'm trying to add a set of records to a table where in that table a field's data type is set to AutoNumber. I can this by copying the records and pasting them into the table. However I would like to simplify the process. I tried doing an append query and it would not let me do it. Actually it...

I have a form where the record source is a query with 2 joined tables. I can not edit the records. Is there a way to do this?

Merry Christmas Bob. Always a wealth of the right information. It worked like a champ. Thank you.

I edited a macro which was mistakenly set to open report and print. However I'm not at a the station where the printer is an it errors then goes to the error screen that says Microdoft has encountered a problem and needs to close. I think it's in the macro but I can't get to it to correct it...

George and Atomic thank you for your response.

My apologies. His issues was an error message "Failure Creating File". He got this when using the export feature after he selected the query and went to File> Export. In the meantime I inserted a new drive and it now works with the new drive. So I'm hoping a re-format of his drive will solve...

I created a db for friend and now he is having issues when he tries to export the results of a query to his external zip drive. He can export to his internal without issue. He was able to do it weeks ago. I asked if he did any updates and stuff like that but he said nothing out of the ordinary...

Thanks again Ken for your help. If there was a place I could get to easy to change a dropdown menu or click a check box I'd do it. I'm not going to travel a down a road designated for 4wd with roller skates. I'll fix it again for him in a couple of years if need be.

Well I don't even know what an api thing means so it's WELL beyond my ability.LOL

Thanks Ken, I seen that in the options for the Start up and I did not know of that piece of code however neither of those work for me. There are three stages for any window min, restore, and max right? What happened both times was while in the restore state it got resized to the size of what...

Is there a way to keep the database window open where it could not be minimized or restored, or minimized or maximized? I know I can do that for forms in properties by changing the Min Max Button setting to none. I want to set the Database Window to none. The user has lost the window a couple...

Has this been resolved in Access 2007? I had to create a text box in Word, rotate it correctly and then paste that into my form as a picture. Strange that there limitations on text direction in Access 2003.

Is the form built on a query?

Isn't there a column property?

Hey thanks. Maybe it is the way. I don't know cause I have never used it. Before I get entrenched in one way or another I was hoping an expert would show me the correct road if there was one. I just finished a db where I went down the wrong road.

Well I just tried thru the wizard and it looks alot like a crosstab. And isn't it for viewing only? Can I edit and add new records? I have never used one in access. I did a couple in Report Services.

No, I haven't. I'll take a look. Have you used a pivot table like this before?