Search results

  1. K

    Intermittent Start up issues

    Hello All, I wrote and Access DBase to run for my company, it tracks various data, and reports as you can imagine, the set up is, all users have a client program, Written in Access, and this is linked to the Tables held on our Network drive, each client then only queries the records when...
  2. K

    Digital Certificates

    OK.. Here goes, Not Sure if this is the correct place, or if anyone can help with it... Ive multiple D.Bases written in access 2003, for different departments, on one stock controller for our maintenance dept. I tried to get clever and use some type of signed certificate to allow my programs...
  3. K

    Number Format.

    My users have numbers to identify forms logged, so.. V0001 V0002 ..etc V0050 But all I can get with my access 2000 / 2003 is: V__1 or V 1 V__2 V 2 etc, Does anyone know how to format my Mask, or another way to show the preceeding Zeros in the number format, also if its not Input Mask...
  4. K

    Screen Updating in Access VBA

    In my DBase Ive got a need to hide the screen changes from the user, does anyone know if its possible in Access .. Ive looked over the help in access(2003) and cannot find it, there is a command it excel "Application.screenupdate = true" and False to disable, Can this be done is ACCESS, ive...
  5. K

    Email using Send object problem

    Ok, I have my Dbase Emailing ppl in a table, because its from a table the list can be endless, basically I use send.object and use a text box on the form for the email addy, then it loops and moves forward one record anf emails again, its a standard msg just needs to go to different...
  6. K

    Access Calender Size Problem

    Im Making a Room Booking System for Our Meeting room, there is only one room, so its easy to use the Calender(MSCAL.Calendar.7)value to pull a query for whats happening on anyone day, this also allows to add new entries, my problem is Ive writting it in MSA2003, and my main user is in 2000...
  7. K

    Sub Form Upsidedown

    In my Dbase, there is the main form, for our Products Partnumber, each Product could have may revisons, so there is a Linked Table showing the revisions, I want the Last one entered, Also being the current one to be at the top, this is not a problem after the data is entered but... when...
  8. K

    Right mouse Blues.

    Is there a Right mouse button Even it Access, But in my form I would like the user to have the left button to select fields (as default) but have the right button either bring up and option menu, like a windows navi, would, or, failing that, have it a find come up searching the field they right...
  9. K

    HELP Email from Access..

    Help, Internally to our Company we issue forms that need filling in by the factory, this form was always done my filling out one at a time every time it was needed and then emailing ppl in the company that needs to know whats going on, so I automated it in Access, through some code I found in...
  10. K

    Filter a Filter

    Im Writing a Dbase to Log our Drawing documents as they come from our Customers.. Now Each month there maybe the same part number but a NEW revision, so the part number is on a form, and the Revision is on a sub form linked so there can be more than one attached to one part number, thats the...
  11. K

    While im online, here is a combobox problem thats been buggin me for ages,

    when you have the values on a combobox, if the user wants to add another value that isnt there already, is there a way I can have them just type it into the combobox and save it in the list ?
  12. K

    I thought it was simple(subformStuff) but Maybe Im just stupid.

    Ive got a form, that has inputs to a table, and it also has 2 subforms that link to another table, the subforms are different forms but they link to the same table, this is bacause I need to be able to enter two different items off the table that may be different items, the reason Ive used...
  13. K

    Linked table look up ??? HELP.

    OK, so now in my Dbase Ive got the main data, and another table with 2 fields in, in the second table its a part number and a weight, on the main data I need the user to select the Part number with a combobox that the weight is filled in the maindata automatically, I dont understand Relational...
  14. K

    Backdoor Shift Key

    I guess using AccessRT doesnt allow for the Shift key to be used as a backdoor code, I guess because I never used it, all the PC's I program for in mycompany use full office licensed to about 35 computers so everyone uses access full not just the RT. SO.. Im finding some users now know how to...
  15. K

    Mouse Wheel / Print Screen Frustration

    Does anyone Know how to stop the mouse wheel from scrolling through the records, my Dbase is for non-computer expert users and the ability to move records to the EOF and see a blank freaks them out, does anyone know how to stop it from working, ??? Same for the Print screen, in normal MS...
  16. K

    AutoMove to the Next Field ?

    In my Data base there is a form for entering various data, 3 of them, are one after another, I understand how to make the fields TAB in order, but what I want to know is, is there way of limiting the field so it only allows 2 numerical values i.e 12, or 01, then on the second keypress, it...
Top Bottom