Search results

Hi: I would like to do a test for values between 2 dates in Excel 2003. Since I did not find a between function I am looking for a different way to test this. Example if range of date is May 1, 2015 up to and including May 20, 2015 I would like to find any Start date which begins on or after...

Hi: I have a form which displays information in the footer until the use has accomplished some tasks. Once I verify that all is well I allow the user to change the fields in the footer. I want to verify that the proper changes were made but the BeforeUpdate event does not fire until the form is...

Hi: Client has asked me to create a report showing summary of monthly sales by day. That was easy. I created a query for the month the user selected and then summarized and group the data by day. Client like the result but would like to see zeros on the report for non sales days. Non sales days...

Hi: For the system I created last fall, the user has asked me to display a report to summarize data by date within sales area. There is no intention of printing the results so I could use either a form or a report and I elected to use a form. Overview of the data: The system I...

Hi: I would like to thank the people who take the time to answer question, decipher problems and post solutions, and those who post code to help others understand Access. I have been the recipient of such help and I would like to say Thank You. Last May I undertook to develop a means, for a...

Hi: Following the suggestion on a previous thread I split my database into a FE and BE to simplify the upgrading of the clients copy. I had a chance to implement that change today and except for this error all seems to be well. The error is "Invalid Operation 3219 " and flags this line of code...

Hi: I have a table with thousands of unique numbers, each of which describes one item. I would like to design a form that the user could use to look for a specific number and then to display the information associated with that number. I was thinking of a combo box but I did not want to...

Hi: I have developed an Access database and now I would like some ideas on how to update the clients version of the database. Some background. The database was developed with A2003 and is being run on A2000. The database is only used by one user on a standalone computer (not networked). Now...

Hi: On my form I have a List Box which has a query as a data source. I would like, within VBA, to get all the items in the list. Is there a way to do this or do I have to define a recordset to access the list. Note: I know how to get the item the user selected. Now I would like to see the items...

Hi: I have a form bound to a Crosstab Query. The form has a list box from which the user can select the items to be displayed. With code I then set the filter to this selected item. However, the form displays all records returned by the Query. I have used Debug.Print me.filter to verify that...

Hi: On a form I have designed I have an unbound field which calculates a result from various table fields. The bound fields and the one unbound field are all set to visible = false until the user has entered some information. Using vba, when the conditions has been met then I set all bound...

Hi:: I started my project several month back to relearn Access after being away from Access for many years. One of my original question was about storing a calculated value and after some discussion I decided to store the value. Now I need to revisit this decision. I receive, after the...

Hi: I am creating a table to store perpetual inventory information. Just to be clear, I am not managing the inventory but rather recording what has taken place. On a daily basis, I import several text files which provide information on what was sold, including product, total quantity, and total...

Hi: In the A2003 database I am developing I need to calculate/store a end inventory count. First some background. The database is a historical collections using daily imported sales data with the primary purpose of analyzing the sales that have taken place and then reconciling the sales data...

Hi: I have created a continuous form bound to a query (X-Tab) where the detail row is a series of unbound text boxes. I then wrote some vba to populate the detail row from the query recordset. (The vba code also populates the heading row which are also unbound text boxes.) Everything works...

Hi: For the application I am developing I have created a X Tab Query to produce a listing in a form (use is unlikely to print this) showing the results of the X Tab Query. Now I need to find some way to automate the query to limit the information based on date. So I am looking for suggestions...

Hi: I have created several forms to allow users to edit existing records from different tables. The user is not allowed to delete existing records nor are they allow to add records. I handle that with the form property Allow Edit/Addition/Deletion set to yes, no, no. On the form I have an...

Hi: I have designed a from which populates a list box for the user to select and item from. After selecting and testing that an item is selected I set a filter to restrict the listed records and then set the focus to the first field which the user can modify. The problem I have is when the...

Hi: I have a select query to display record from a table. I would like to lookup the closing value for the corresponding record for yesterday. I have coded the following DLookup to get that data and it works if I hard code the date. Now I need to change it to be current date of current...

Hi: I have a form with a command button and some VBA code. After checking that the user has done all that needs to be done then they can click on the command button to print a report. I am having a problem with the report. The error message I get says I have "Written a subquery that can...