Blank New Form Is No Longer Blank?

Apr 11, 2006

Hi guys,

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?

Any ideas?

Thank you in advance

View Replies

Forms :: Way To Continue To Blank Form After Entering Information Into Previous Blank Form?

Mar 25, 2013

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.

View 7 Replies View Related

Queries :: Pulling Records Based On Blank / Non-blank Criteria

Jul 18, 2013

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...

View 3 Replies View Related

Query Criteria With Blank And Non-blank Text Records

Mar 13, 2007

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)

what else can I do?

Thanks

View 5 Replies View Related

Blank Form

Aug 21, 2006

Hi,

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?

Best regards
Keith:(

View 4 Replies View Related

Blank Form??

Dec 1, 2005

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?

Ay ideas?
Thanks

View 1 Replies View Related

Need Blank Record On Form

Aug 1, 2006

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?

Thanks,

Toni

View 3 Replies View Related

Edit Form To Appear Blank

Apr 27, 2007

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.

View 1 Replies View Related

Display Blank Form

Mar 7, 2005

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"?

Thanks,
SKK

View 5 Replies View Related

Blank Record In A Form

May 5, 2005

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.

Thank you for any suggestions.

View 2 Replies View Related

Form Display Blank

Aug 14, 2005

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.

View 3 Replies View Related

Blank Form On Open

Aug 27, 2005

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?

Thanks
Rod

View 1 Replies View Related

Opening A Blank Form

May 14, 2006

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

View 3 Replies View Related

Printing A Blank Form

Sep 1, 2004

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!

View 1 Replies View Related

Printing A Blank Form

Aug 23, 2004

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:

PCL XL error

Subsystem: KERNEL
Error: IllegalStreamHeader
Operator: 0x0
Position: 0

Here is my code for the print button that I created:

Private Sub cmdPrint_Click()

On Error GoTo Err_cmdPrint_Click
DoCmd.PrintOut , Me.CurrentRecord, Me.CurrentRecord
Exit_cmdPrint_Click:
Exit Sub
Err_cmdPrint_Click:
MsgBox Err.Description
Resume Exit_cmdPrint_Click

End Sub

Am I using the wrong code? I really need to be able to print a blank form!

View 3 Replies View Related

Form Blank Fields

Feb 12, 2006

How do I make a form open with blank input fields?. The one I made always has a prior record displayed.

View 1 Replies View Related

Switchboard To Open New Blank Form...

May 30, 2006

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.

Any help will be greatly appreciated.

View 2 Replies View Related

Form View Screen Is Blank

Aug 7, 2006

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?

View 2 Replies View Related

Open Form To A Blank Record

Feb 3, 2005

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.

Thanks

View 2 Replies View Related

Data Entry Using Blank Form?

Apr 6, 2005

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.

Can anyone help? :)

View 2 Replies View Related

Combo Box Blank When No Records On Form

Dec 30, 2005

Hello,

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.

Anyone know how to fix this??

View 5 Replies View Related

Extra Blank Line In Form

May 23, 2006

I have a pop-up form in Continuous Forms mode used to enter notes tied to the id field of my main form.

Two fields - notedate and status. Everytime I click in the blank field "status" another blank record always shows up underneath.

I have "notedate" set to auto fill when the focus is set to "status" and this is creating extra records in my table.

Is there a way to stop this from happening?

"Cycle" set to All Records - changed to Current Record with no difference.

Private Sub status_Click()
If IsNull([notedate]) Then
Me.notedate = date
Me.status.SetFocus
End If
End Sub

Private Sub Form_BeforeInsert(Cancel As Integer)
Me.negid = Forms!OpenContracts!negid
End Sub

Thanks,

Toni

View 4 Replies View Related

Show Blank View On Form

Oct 13, 2006

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!

View 5 Replies View Related

Blank Record Upon Opening Form

Oct 31, 2006

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.

View 2 Replies View Related

Blank Form In Access 2007

Dec 23, 2006

Hi,

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.

Any suggestions?

Thanks

Daniel

View 3 Replies View Related

Not Displaying Blank Fields In A Form

Oct 7, 2004

Hey Guys,

This one could be a tough one.

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.

Is this possible?
Thanks!

View 5 Replies View Related