Recent content by Garn77

In trying to write code to automatically hide database window I have completedly stffed up and now have code that closes the database window everytime I startup, hence closing the database. Does anyone know how to disable VBA or somehow keep the database open??

Hi I am having trouble conceptualising how to pull this together. Firstly I have data that comes in each month from various locations. At the intial stage all I want to do is enter the data for each location which consists of collection and reporting dates and a series of fields, some of which...

Ansentry Thanks heaps, perfect solution

Using Access 2000 I have included a temp version of the database to illustrate what I want to achieve. For each entry into the form I want to record all fields from SiteRegisterID through to DisposalD fields. After the first entry I want to select the "Next Entry" button which will move the...

Ansentry Thanks for the advice, this is what I am looking for. However, in trying to reprogram the code I am experiencing trouble and having errors accessing a file??? Can you assist further, sorry a beginner with code formatting

I have tried in vain using refresh programming to overcome this, I have a main form that records site and date information. Within this there is a subform that records a number of fields that are standard, but differ according to site location, so that it appears like; Offsite1...

Pat I put in your formula on my unbound fields and it still wont work Aggghhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh!!! :mad: I need help badly, what can you suggest i look at, I used the cboCodeID formula, se Selecting from a combo box with the aim to fill in another combo box and 2 text...

Office guru, I'm trying to produce the same thing, a combo box that can be used to select a refernce number and subsequently 3 other text boxes will autofill (2 of which are in a subform), please can you run through what you did so I can get this right?? Thanks

I have a main form with two combo boxes, and a subform with two text boxes. All the information for all four boxes is included in a query, with the etered and generated information to be recorded in a seperate table (the reason for this being that want to record other data with the mentioned...