Search results

  1. Navyguy

    Works in Database View but not in Switchboard...

    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
  2. Navyguy

    Mail Merge from a command button

    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...
  3. Navyguy

    Opening form based on query result

    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...
  4. Navyguy

    Memo Box to Word

    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
  5. Navyguy

    Issue Jobs Evenly - a little challenge

    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...
  6. Navyguy

    Tournament Database

    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...
  7. Navyguy

    Integrating Into A Word Document

    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
  8. Navyguy

    changing button colour?

    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...
  9. Navyguy

    Autonumber is easy...yeh right!!!

    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...
  10. Navyguy

    Autonumber is easy...yeh right!!!

    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)...
  11. Navyguy

    Autonumber is easy...yeh right!!!

    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...
  12. Navyguy

    Autonumber is easy...yeh right!!!

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

    Autonumber is easy...yeh right!!!

    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...
  14. Navyguy

    Autonumber is easy...yeh right!!!

    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...
  15. Navyguy

    Database read-only?

    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
  16. Navyguy

    Julian Days

    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
  17. Navyguy

    Hiding Menu Bar

    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 :)
  18. Navyguy

    Hiding Menu Bar

    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
  19. Navyguy

    Hiding Menu Bar

    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...
  20. Navyguy

    Need suggestions for practice material

    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...
Back
Top Bottom