Search results

Hi, I have attached the database that i am currently working on. It will be to track my companies hires. I am having a problem with the subform that will be used to enter all the specific items - it is on page 2 of the tabbed box. I have included 2 main forms and 2 sub forms to show what...

I would have thought you could simply highlight the controls that you want, cut them from the tab control, delete the tab control then paste onto the now empty form. If you have several controls from different pages then i would cut and paste them onto a new blank form then delete the tab...

Create a table and have it in a single field with NextTicketNumber / Number any time you wish to create a new number you need to go and read from this field then update it by 1. Why don't you want to use an autonumber though?

I would include everything - so you will be able to present the manager with a list of exactly what is on each pc - this will also show how many copies of each program there is and will help them decide if they have enough licences to cover them. It will also let them see what is on the pc's...

You can disable it for a whole form by going to the form properties Other -> Shortcut menu and setting this to No

It might be somthing like the references for the project that is causing problems. Open up each database and goto a code module - choose Tools->References. Make sure the references are the same/same order. Even just them being in a different order can cause problems.

Where is the front end part of the database stored? On the users pc or on the server? If its on the server try running it on the users pc instead.

I have Norton Internet Security 2004 installed and don't get any pop-ups.

Try compacting your db then zipping it. That should shrink the size considerably.

Create a branches table - This will hold their company details etc for that specific branch. When you distribute it to a new branch make sure this table is blank. When they load the database - have it doing a check on this branch table - if it finds anything then these are the details it will...

Try a Compact and Repair first. Try going into a code module and Debug->Compile All (or project name- i cant remember which it is off the top of my head) If this still doesn't work the following will :- Open the form in design mode. Open up the properties window. For each control where the...

It converted to both 2000 and 2002 for me. Guessing 2003 would be fine too.

I don't really understand what you mean - any chance of a screen shot from Approach?

You can turn off right clicking for the whole form by doing the following. Go to design view - properties for the Form - Other - set Shortcut Menu to No. Never tried to see if you can do it for an individual control though.

Why not post your database up here? I am having trouble understanding the problem after reading all your posts.

try this - change text2 and text4 to be the names of your text boxes. Private Sub Text2_Click() Text2 = Format(Now, "hh:nn") Text4 = DateAdd("n", 30, Text2) End Sub

I did a post on the sample databases as a workaround - its only on Access 2000 onwards though

Just copy and paste what i stuck in at the end of my post - just add it into the code for that form - just stick it right at the very bottom - that means you can call that code from this form only. Fot the button you have already made - UpdateButtons at the end - and that will go off and jump...

I was going under the suggestion that it would not be a pre determined list and that the user would be able to type whatever they wanted - hence why i suggested that method.

If you need to specifically type something in - rather than be able to have a preset list box then you could do it in code fairly easily. On the AfterUpdate event for the text box - You would need to go through the text box using a loop and strip out each set of criteria then add it onto a...