Search results

Thanks WayneRyan, works great! You wouldn' know how to do the same with a table on a chart? I went ahead and changed the format in the supporting query however the values in the chart table do not appear to change.

Does anyone know how to force a listbox to display an additional level of accuaracy in a listbox which displays a value based on an expression in a querry? My querry displays the value to 4 decimal point but my listbox only diplays the value to 2 decimal point. Thanks!

Ducker, Well I ran the querry in question without using the double click. The querry ran fine. And now everything is working, including the double click! Not sure I understand why but am happy thing are back to normal.

Ive created a database that has been working very well for over two years. I have made several modifications over the years with no major problems. The database was originally created in ACCESS 2000. On one of the many forms I have their is a listbox with an event triggered when double cliking...

KODO, yes I did and still get the promps. I might try assigning some value to the parameters prior to closing/quiting.

My Master Form has a command control "Quit" which triggers DoCmd.Quit on click. The problem is the user is prompted to enter parameter values before Access will close. It appears the parameter values support the SQL for list boxes on the master Form. Any ideas on how to remove the parameter...

The form is bound to a "temporary table" created from appending all the fields in the "Past Data" table with the addition of the check box fields. When the updates are completed (via form in question) queries update the "Past Data" table and append historical data to a "history table". The...

No, I have several (approx 12 or more) fields that need to be updated depending on which check box is selected.

I have a form bound to a table of past data. On the form I have a series of check boxes that when checked a number of related textboxes must be updated, cannot be Null. The problem is I cant set the bound tables fields to required but I need to have the forms fields contain a value when...

Continuous Form Help, text box update. I have a Continuous Form based on a table of multiple records. With each record I have a check box "chkRplcd" which is checked if a piece of equipment is replaced. I also have a bound textbox "txtEquipDate" which specifies the date of that particular piece...

I like it!. I completed my project earlier using the array in around about fashion but am studying the attached file to use on the next phase of the project.

Thanks Pat, Your correct I do not need the listboxes, I would prefer to populate the temp table directly from code but I am not having any luck using the array to complete this. My Access help does not appear to have much info on recordset properties for tables. I am rather new to VBA code.

Pat, I get the following error @ Me.lstAvailableItems.RowSource = Me.lstAvailableItems.RowSource & ";" & myarray(i): Run-Time Error 2176. The setting for this property is too long. It must have something to do with the long path I am using? Private Sub cmdCopyFiles_Click() ' Dimension...

Hello everyone, I need some help. I'm using the attached .mdb file to populate the table "tblPhotoInventory" with .jpg file names from the path speceified in "txtpath". The problem is I have over 600 files in each of the 250 paths"folders" the code will only allow me to populate 29 file names...

Has anyone come up with a solution to this? I am experiencing the same problem and have not come up with a clean fix.

pmcleod Yes that could work. however I did get the parse VBA code to work by copying code from another post. I'm just working on how to deal with "null" values since the code doesn't seem to be setup to address this. Thanks for your input!

Fofa, Yes, I agree with the concerns regarding data entry, good point. Maybe there is a better way of approaching the data acquasition? Let me explain the situation further. I work for an electric utility which hires contractors to inspect our structures. The contractors have been providing...

I have a database which imports Excel field inspection data into my Access main table. The only problem is the Excel table has a field labeled defects for each record which has a number(1-35) corresponding to a particular defect. Some records have zero defects(null) while others may have...

I have a form with several listboxes based on seperate SQL recordsources. I want the user to be able to view the SQL in datasheet view by simply double clicking th list box. I've done this in the past when the list box record source was a query by opening the query in Datasheet view. Ex: On...

Yes, But I think I'm on to something, when I view the properties of all the slow tables the Subdatasheet Name = (Auto); If I change this to (None), like the faster tables, they seem to open just fine. Now I have to fiqure out what "Subdatasheet Name = (Auto)" means; and determine what impact...