I have a couple subforms within a main form for which all have a couple memo fields. I'm only getting 255 characters input when I should get over 26,000....

I have tried to without success to have a calulated time elapsed field in my subform. It involves an original date on the main form and a later date in the...

I use the switchboard wizard in 2007 to create a switchboard but when I go to look at the finished product the main switchboard page shows no items. If I...

SELECT zDepartments.DeptID, zDepartments.DeptName, zDepartments.DirectoryID FROM zDepartments WHERE (((zDepartments.DirectoryID)=!! !)) ORDER BY...

DoCmd.OpenForm "Fuel", , , " = '" & cboCustomers & "'", acFormReadOnly The above code works fine. However, I'm looking for a more efficient way to retrieve...

Hello! I have a problem with form, because when I call form by itself, it is set to Datasheet View, but when I call that same form with button on the...

I have a form with a name box and one with the email. What i am trying to do is as you type in the name it will go ahead and fill in the name as you type and...

Hi I have searched for this answer, however this forum may be my salvation to this prob' As I have a lot of repeating fields to fill in it would be handy...

Hi, How to set up a purchase invoice in access 2007? I already create Queries (Date, Customer Name, purchase item, quantity, unit price, amount (quantity x...

I have a form displayed in single record view with a command button on it. When I click the button a copy of the same form opens as a pop-up in datasheet...

Turn Your wounds into wisdom Fawzia Gul Shah Foundation is dedicated to Late. Sultan Hazrath Mohammad Gul Shah, and his beloved wife Begum sarah decendant...

hi, sorry to disturb anyone again i have 2 tables in my database 1 for tblCustomer and 1 for tblOrders for my tblCustomer i have the following fields CustId:...

A2003 Datasheet view form bound to a table. First column is bound to primary key ID and I cannot sort by it (context menu is greyed-out for...

How do you go about setting up an edit form without having the user access the tables. I have forms built and each also has an edit form. I am afraid since...

Hello, Is there a way to see the date the transaction was entered in a table? Thanks in advance

I have the following code on the BeforeUpdate Event of a control: If DCount("", "RAdioInfo", " =' " & Me.ODUSerial.Value & "'") 0 Then MsgBox "This...

I have a form with a close button with the following code. Private Sub btnCCRClose_Click() On Error GoTo Err_btnCCRClose_Click Dim ctl As Control For Each...

Hi, I need help in filtering data on a form, because it is behaving in a strange way and it really puzzles me. The database was originally written for access...

I am trying to add (sum) three fields on a form into another field using =Sum("",,"") But I keep getting errors. I've moved many operations around and I can't...

I should know the answer to this but I am drawing a blank. I have a database with a pop up form. From the popup form, I want the user to be able to click a...