Search results

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!

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

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

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

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

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

I've got a strange problem, all the tables which I've created in my latest database "DB-B" are slower than molases. However, if I import a table from one of my previous databases "DB-A" the imported table is lightning fast. For example: I've got a simple table created in DB-B, 9 Records, 1...

I have a simple 3-d Column Chart originally with 6 columns. I recently added a column to the underlying SQL and adjusted the coulmn count property of the chart to 7. The problem is this; the chart looks fine in design view but when I save and view in print preview it reverts back to the...

I have a series of cascading combo boxes used to fill out entries in a form. Ex: Coat/Shirt/Pant Then Red/Blue/Green/ Then s/m/l Then Product#. As the user filters through the combo box only (1) Product# is available at the end. The problem is the user must select "click" the Product# in...

I have a line graph chart based on a cross tab query in which the Data Table is displayed. The problem is in the Data Table the values are displayed to 7 decimal points, I would like to limit the display to 4 decimal points like in the underlying cross tab query. I can't seem to make this...

i have created a stacked area chart from a crosstab querry. My problem is the chart works off filtered data, when I change the filters my rows change like they are supposed to but the graph color does not stay conected to the row source. Is there any way to assign a color to a row source?

I would like my db to compact on close if the file size exceeds xxMB's. I was trying to use an IF..Then..Else statement in VB, But I cant seem to find the command or code which will identify the current file size. Any ideas?

I work for a large corporation and have been involved in the creation of four recently created Access 2000 Databases. The databases are used by 40-50 users in two states. All of the databases are linked to servers in one state "backend" with the front ends usually residing on the users PC or...

I have created an Access 2000 database which is about 15 megs in size. but after an hour or two of generating reports it jumps to over 100mb. what could cause this? I can perform a compact & repair but this takes some time.

Through VBA I am using a module which contains the apiGetOpenFileName lib comdlg32.dll to select multiple *.dat files, then VBA code to convert those files to *txt, and finally (using an import spec) import those files into my Access Table. The process seams to work fine until I select over...

Hello, I have a simple table with 2 rows containing: Row1) Work force avaliable hours (count per month) Row2) Work force Required hours (count per month) I want to create a simple column graph to compare the values for each month. The graph is very easy to create in Excel but I am not having...

I have a table which records the Start date and End date for various work groups, but now i need to record the total projected hours per month based on a 40hour work week. This is getting more complex than I anticipated, how can I account for weekends and Holidays? Thanks in advance for any help!

I have an access file which is used by several clients throughout our company. My problem is the file is constantly being revised an it isn't practical to instruct the users to replace the file on thier pc with the latest revisions from the server. Is there a way to prompt a string of code to...