I have been running the same database on numerous systems for 5 years and the user clicks on a button and using this code;
DoCmd.OpenForm "Employee", acNormal
Simple !, this always opened this form blank, without applying filters, ready to accept a new employees details.
But now this no longer works, for no apparent reason?
What happens is that it opens with the form fields filled with the first person in the Databases details instead of being blank.
The only thing that could have changed is that i converted the database to 2003?
When entering information into a blank form, I would like to be able to continue entering information to another additional blank form after my last entry. Is there a way to continue to a blank form after entering information into the previous blank form? I would just like to continue without having to close the entire form and then reopening another form.
I have a couple different reference files that get updated each week. Sometimes there are missing data elements, so I'd like to structure a select query to show me those records that have blank elements but I'd like the similar records to be pulled in as well, so I can make a determination as to how to populate the blank records..
See attached example: I have a client ID reference table that gets populated with forecast owner names (individuals responsible for the customer) from a couple of different sources. Sometimes there are names attached and sometimes the field is blank.
How can I structure a query to show me just those Client ID's that have multiple entries with blank AND non-blank forecast owners? I'd also like to exclude single/multiple records where there are only blank records...
OK, I have been searching around on the fourm for over an hour now...I give up. If this is some where else, I am sorry.
I have a database of maintenance data. There are several columns that are usually filled in, some records have some columns blank. They are formated text because they hold letters and numbers (see pic).
I am using a form to query the table...no problem. The form has text boxes the user filter down the data
The problem comes are with the results of the query. Any record that has a blank column is not retuned. I am using "Like" so that the user can enter in partial codes. I know "like" won't return "null" records.... Help!
Things I have tried: 1)IIF(form field is blank, return table field, else use like command to filter) - returns nothing! 2)Like "*" & [Forms]![Fleetwide_data_Request]![MAL_CD] & "*" returns all records without blanks (i.e. missing data)
I have created a switchboard for a very basic DB and the first button is "ADD A NEW ENTRY" When I click on this a form comes up but it bears the data from the first record. How can I edit it so that a blank form comes up ready to receive data?
I'm creating a form, from various tables, all linked accordingly. But when I run the form report wizard, I insert all the fields I need, then when I preview the form, its blank?
I have a form with a drop down of employee names and a tabbed subform.
I have the form and subform set up to open on a new record and, when the employee name is selected to fill the subform with that employee's data.
It is a split db with the be on the network server and everyone has their own copy of the fe. When I open the front end the combo box is blank but the first page on the tabbed subform shows data. If I close it and reopen it, sometimes its blank and other times it still shows data.
What else do I need to do to ensure that it is a blank record?
Also, I am using the MouseHook.dll and included it in my .exe (zip) file to all of my users, instructing it to download to the same location as the .mdb file (C:/Training Database). Will this work or does the MouseHook.dll need to be somewhere else?
I have searched the forum and didnt find an answer to this. I have an Edit Form. When it is opened, it displays the first record. I have a Combo Box where I select the specified ID and the relevant record is displayed in the form. What I want is that the Edit Form should be appear blank. The record data should appear only when I select the relevant ID in the Combo Box. How do I achieve this? Please help.
I have a DB with a form based on a query where we keyin a parcel identification number (PIN). If there is a corresponding PIN the form opens. If there is no PIN available, a blank form appears. Is there a way that if no corresponding PIN is found, a different form or message box would open stating "No parcel available"?
i have a subform as a continuous form, and at the bottom, there is the normal blank record (created automatically), to enter a new record. Is it possible to attach a piece of code to a field but which will be available only to the field of this blank record, rather than being available for the particular field of all the records in this continuous form ?
Basically i want that if the focus is on this blank record, and i will hit the tab key i want to move the focus to a control, on the main form, that's why i want it specifically, when only this blank record at the end has the focus.
I am trying to build a form with feilds from multiple tables in access 2002. When I use both the design view or the wizard to build the form, the form displays in design view, but is blank and unusable in all other views.
When I open a form, it displays the first record from the table that I defined as it's Record Source. I want the form to open with all the fields blank so the user can begin entering data. What do I need to do to get the form to open without any data in the fields?
How can i open a form to add a new entry in a blank format. I currently have a button which opens a form but displays the information of previous entries.
I would really like the form to open without displaying any previous entry
I created a form that opens to a blank form. I also have a print button on the form. I want to be able to print the blank form, but nothing happens unless the primary key has a value in it. Is there a way to print just a blank form? I have been working at this problem for a few weeks. Please help!
I have a bound form that I created. I want to be able to print a blank form. When I click on my print button, nothing happens. Also, when I click on the print icon, I get the following error:
Just curious. I'm trying to set up a switchboard to guide users to the right place in my database. I would like to have one button on the switchboard to open a standard form with all the infomation in it already. and then I would like to have a button to open a form that is blank and then adds to the previous form I mentioned.
Hi, i have my form open in design view and it includes quite a few fields on a tab. But when i go to open it in form view, the form is just grey and nothing appears on it. Never seen this before, can anybody help?
I have a form that is used to both Enter & Edit records. There is a "search" button to aid in finding records. I have been asked to have the form open to a blank record instead of the first record in the table. Is there a way to do this without setting the "DataEntry" property to true, as this basiclly disables the "search" button.
I have searched the forum and asked some of my colleagues about this and I do not seem to be getting anywhere. :(
What I need is to be able to use a (blank, ie showing no current records) form to enter data into a new record.
I have Tables A and B in a 1-to-many relationship and I need to be able to bring up a blank form which has:
1. a combo box, allowing me to select the relevant record from the parent (table A), and ... 2. blank fields (from the child - table B) to fill in with new data.
I can set this up using a standard setup, where all records are shown, but this is confusing to a dumb user, who really only wants to see relevant boxes for them to fill in without the distractions of data in fields they are not concerned with or with other records they do not want to know about.
I have an unbound combo box in the header of a continuous form. The box is set to value list, and when you select a value, the recordsource of the form is changed. This works fine.
However, if I there are no records in the underlying form, the combo box is blank. If I check the value in the immediate window or the after update, I can see that it is set properly and contains a value, it just doesn't display it. I am using Access 2000. I have tested on Access 2003 and cannot replicate the problem.
I have found one post here (http://www.access-programmers.co.uk/forums/showthread.php?t=84423&highlight=combo+box+blank) on the topic.
I found this (http://support.microsoft.com/default.aspx?scid=kb;en-us;287478) article on Microsoft which has my symptoms, but I am not opening a recordset.
I have created a form from a table and only the startup screen when I hit the button I want the form to display a clear entry so that I can create a new contact each time - at the moment when i hit the button it shows the first record and im in danger of changing it (im having to hit the create record button) Help!
HELP When the user double clicks on the icon, the form automatically appears on the screen. That's good. But record number 1 is there. I want a blank record there so they can enter their data. This can't be difficult, but I can't figure it out.
I have installed Access 2007 and I have tried to run my program written in access 2003 and 2000. It seems to work with a few bugs but my biggest concern is about one particular form. When I open it, I can see the headers but no data. Of course the query from this form is not empty.
At the bottom of the form, I have a total of the records and other calculations but the data are not visible. ( In access 2003, there was of course no problems)
What is very strange is that other forms of my program are well visible.
I have a form that displays products information. The products table has about 30 fields but not every field is used in every record. Depending on the product I would like those fields that are blank not to appear on the form and then for the form to be reorganized so there are no odd spaces.
