Search results

I was just wondering if the event procedure or macro is selected for the OnClick properties of the button. or maybe the form is set to data entry... Navyguy

Try this. I use this to print several different documents from different buttons based on a query. I press the button, merges the documents and prints and closes all in the background. You don't even know you are printing a word document. I got lots of help from the forum on this...

Perhaps you can try the NZ(DCount) function. I had lots of help with this from the forum and it works great. I use it to search for three separate criteria and if all are present it opens the form with the required data. If any one of the three fields are not present a custom message box...

Sounds like you want a simple merge. There are tons of merge threads in the forums, just give a quick search and see what you come up with. Also there are several documents on the Knowlege Base Support Site of MS. Navyguy

Just a thought, A job is not a job is not a job... You might consider the length of time to complete the job/task verses just the job/task itself. Not being a techie, I would think that setting up a new workstation c/w software, server connections, etc takes alot longer then replacing Bill's...

I have started to tackle another volunteer project/idea that I thought may be interesting; a tournament database. I have on paper at least, think I have a good grip on table structure, queries, etc. In idea that I am thinking that may be a problem is the bye system in a report format. I would...

I just completed this http://www.access-programmers.co.uk/forums/showthread.php?t=62159&highlight=MSWord Hope this is helpful. It works great for me. Navyguy

What I have done is I made my cmd button transparent and slightly over sized, then placed a coloured label behind it. Make sure you use the "send it to back" for your coloured label. In the web address of the button I put a space so the pointer changed to a hand so the button was identified...

Well Rob I must admit I am happy that it is an access problem and not a "me" problem. I thought I was missing something so simple (which is usually the case). It is interesting that you can't do this though without creating separate forms to accomplish what a SForm will do...Sort of defeats...

Ok Rob I read your reply a couple of times and think I have what you said. What I am missing though is why this only happens when I changed it to Autonumber and not when it was a text field? Is the process not the same? If you look at the main forms, you can add several (unlimited)...

Thanks Rob, I appreciate your help!! Heres more stuff... I included the sample tables for the forms and one dummy record. I encountered the problem on these frms/SFrms that I am sending you. Basically they are the same, but I set one up for data entry. (I read how to do that in a post some...

Here is some forms for you Edit: I deleted the file, enough stuff on the server I suspect :p

Hi Rob!! What I did was delete all the records in the main table where the field was the PK and all the related records where that field was joined, in fact I deleted all the records in the DB!! I changed the field from text to Autonumber, reestablished my table relationships, compact and...

Hi Everybody I have been searching on and off for the last couple of days looking for an answer and can't seem to get a grip. Not even sure if this is the right forum... My db that I have been building was going pretty good and I thought I would make one of my fields an autonumber now that...

What I do... Before you open the DB, right click on the DB Icon; Select Properites; Make sure the "General Tab" is selected; Unclick "Read Only"; Click "OK" Open DB as usual Navyguy

Just out of interest, most of the worlds' militaries use the Julian date format. Wouldn't want to be invading a country on the 2 Jan when everbody else is showing up on the 1st of Feb!!! ;) Navyguy

Spelin thing more gooder Asprin, Aspirin Hid, Hide Normalisation, Normalization No wonder I have problems with Code :p I probably would have keelhauled myself but would have needed to many "pain killers". :rolleyes: Navyguy :)

Anthony your right...just my attempt expressing my lack of ability to keep things straight. Consider myself suitably flogged!!! I will try both of your suggestions and will get back. Any thoughts on the hidden button to restore? Navyguy

Asprin is good for you, but if you take the whole bottle it kill you!!! Hi to all I have read so many posts on hiding toolbars and menus, I don't know what to do... :confused: I tried ghudson's example of hiding the menu bars and such from the FAQ area and I though it worked great. I...

Hi watrout I am very much in the same boat (excuse the habit). What I have been doing is just taking some simple instances where I start trying to do something then build on it. I get both allot of ideas and help from this forum. It is an excellent resource and so far everybody is more then...