Recent content by GoinDeep

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.