Dear all, I had a problem with the Access2003 database. Users use an access database in a server's share folder in the LAN. When double click a form in the...

Hi , I'm wondering if there is a way for me to export some tables including data and structure from old database to a new database and then save as new...

I'm certainly no expert in Access, but this has got me scratching my head... I've got a form with a list box, used for locating the record I want to view....

Can any one please help me how to i check the first character in a variable. If user dont put 0 in the start of a variable the program automatically insert...

I have created a database which hold customer details, stock control and sales. I am having difficulty with the following. When I sell and Item I need this...

Hi all, This may seem like a silly question given Access is a database management tool, but I am working on a project to develop a change management tool that...

I have a form with clients’ data (clientID, clienteName, etc.). I need the field clientname to be automatically filled after the user tapes...

I thought I had this problem licked but I don't now. I have a subform with the following ProductName UnitPrice CostPrice Quantity UnitSubtotal CostSubtotal...

I have a text box which is being appended from another one. I'd like each addition to appear in alternate colours! Does anyone know of a way that I can...

How do you suppress the action query warning message when you run make table query and the table exists? Thanks.

Is it possible to color some of the values in a combo box one color based on a criteria and others another color?

Please give me a push in the right direction On a form with source TblHarbourcost fields Dues Pilotage Tugs I have to fill in the length of a...

When I put this code in the Form's Open event it does maximize the form, but is there a way to keep the design of the form centered in the window? In other...

Does anyone know how to disable the scroller on the mouse when viewing and altering forms as i do not want to be able to filter through data upon loading a...

Hi there Upon opening a form I would like the form to default to a new record. Additionally I would like all old records to be hidden from the form...

I have a main form (Form1) - in the main form there is a button that open a form (with OpenForm) Form2 - I use this Form2 to select a value from a combobox for...

Hello I am struggling with a simple task that is complicating my morning. I have a simple start up form where I want to add few textBoxes that sip data from...

I currently have a checkbox and when this is clicked i need it to alter a further field to bring up the date on which it was clicked. I managed to do for...

I created a simple form in Access 2003. How do I force Access to prompt me before updating a record? -- WCSC (Willies Computer Software...

How is this done? I can't seem to get it too work... I'm using: Me!Forms!MasterOwner!DoCmd.GoToRecord , , acNewRec