Search results

I'm here......... Hey RuralGuy. How can I help? Bizzy

Thanks No worries. Look forward to it. Cheers Bizzy

Here's the file Thanks for having a look. Hope it makes sense. My boss only needs it by the end of the week. Pfft. Don't mind the Employees table and everything linked to that. That is something seperate. Thanks Bizzy P.S I worked out why it was so big. It was the Company logo file.

That's Awesome. Only problem is I compacted and repaired it and it's still 21.9 meg? Is that due to forms? Any way to make it smaller?

Ok then..... Currently I have my form with Client Details on it. I then have a subform (in datasheet view). In the subform they select a temp worker. I need it so that if the Temp worker is NOT in the drop down list that they can add it and select them. Is this possible? If So how? Bizzy P.S...

New Record I go to a New Record because they use this button if the Temp worker they are trying to find isn't in the drop down list. So they open the form to add a new record (temp). Is my code ok?

Here you go Private Sub cmdAddNewTemp_Click() On Error GoTo Err_cmdAddNewTemp_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmAddTemp(NewClientObservations)" DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.GoToRecord , , acNewRec...

Riiiight? I'm not sure that I know how to do that? Any chance of the code?

G'day, Currently I have a button on my form that opens a second for to Add a New Temp Worker. This all works fine but when I close the form and go back to the entry form the subform hasn't been refreshed and so the new temp isn't in the list. I can't close the form that contains the subform as...

But..... I understand that, maybe I should have added this into the original post. Sorry. The temp name is used as a lookup in another table and when you view the list it has blanks in it. Can you stop this?

Hi Guys/Girls, I have a database that contains Temporary workers names. They need to be able to add a new Temp worker, however currently the TempID is an autonumber and with my current set-up (which I'm sure is wrong) when they open the Add New Temp form and type just a single letter but decide...

Fixed! As with many other Users I accidentally edited the System.mdw file. So I simply followed Ghudsons steps and replaced it. Now it is working A-OK! Cheers, Bizzy

Hi, I just went through the User-level Security Wizard and added security. I now can't log on using a username I created. How can I get my database back? I have the back up file but how can I get all the stuff back without this security on the database? PLEASE HELP!! Cheers Bizzy

Why call me?

How do I set up my database so that a password is required if the User tries to press F11? Any ideas? bizzy

Thanks Neil, have got it all working with a junction table. Thanks again for your reply. Bizzy

Hi, I'm new to this forum so forgive me if this thread is in the wrong section. I'm currently creating an OHS&W (Occupational Health Safety & Welfare) database. My boss has just requested if I can possibly have it so that when a Employee has a job title selected for them it automatically lists...