Search results for query: *

Hi - I have multiple "Multi-Select" listboxes setup on an Access form. I am trying to get one listbox (SelectGLDept) to populate the next listbox (SelectHRDept), which has a query behind it (QryMenuHRDept)to populate the second list box. For example, the user chooses the GL Departments from the...

I would like to duplicate a record that also contains a subform. How can I do this?

How can I sort by a Calculated field on an Access Report? I have various fields from a query that I am using to created calculated values on a Report. I need to sort from these calculated values and can't figure it out. Any help would be appreciated. Thanks!

Hello - I'm sure this is a simple problem, but I just can't seem to get it to work. I have a simple invoice report that I have put a subform into. I total the subform and then reference that total field on the main report. It works great when there is data, but if there is no data in the...

I need some advice on search filters/combo boxes design. What is the best way to search for multiple criteria in a list of data? I currently have a list of data in the detail section and on the header part of the form are three combo boxes that filter the data upon selecting data in the combo...

I have an issue that has stumped me. I have created a shipping database that's end result creates an Invoice. The Invoice is a Report that grabs data based upon the date and Vendors specified in a pop up form before the Report is opened. The Report uses calculations and a subform to figure out...

How can I grab a calculated value from a report and paste the value into a table? If I can do this, where would I place the code and how would I reference it? Thank you!

I have some code that puts data from my Main form to my subform. Everything in the code is working great, however, I would like to put a clause in the code that says if my Subform fields already have data, to abort the whole code. When I put in the following code, nothing happens when I execute...

I would like to paste the value of one field on a Main form into selected records in it's subform. I have a button that I click which then executes the "Set Value" option, however, only the first record's field populates. How can I make this work?

I would like to be able to Select All for a Combo box I created. I followed the SQL suggested on the Microsoft site, and the "(All)" option is showing up in the Combo Box as an option, however, my query for the report is not recognizing that it needs to display all the values. Could you help me...

I need advice for a Shipping and Invoice database I have created. I have tables for the shipping data, vendors, location, Purchase Orders, etc. Then it all comes together by date range (they do invoices once a week)and location/vendor in a Invoice I created in Reports. The problem I am having...

I am working on a MSDS database. I would like to have the user enter codes into one field that will automatically populate another field with the full description. All the codes will have to be entered into one field separated by commas. For example: Field 1 (user inputs): RG, RB, RA, FU Field...

How can I link to a field from Form1 to Form2's subform? I have a search button on Form1 that links to the ID number on Subform2, but the error message says it doesn't exist. Thanks in advance for any help with this! This is what I have so far: [Forms]![Form1]![ID]=...

I am trying to create Buffet Coupons for our hotel Front Desk to distribute. The user would input the guest name, expiration date and number of coupons into a Access Database. I would like to multiply this single record with the number of coupons needed and insert it into another table. This is...

I am trying to create Buffet Coupons for our hotel Front Desk to distribute. The user would input the guest name, expiration date and number of coupons into a Access Database. I would like to multiply this single record with the number of coupons needed and insert it into another table. This is...

I need to number records sequentially on a form (similar to the RunningCount funtion on a Access Report). How can I go about doing this? The number should adjust each time a record is deleted or added. Thanks!

Hello - I have a datasheet that contains multiple fields/columns, and these fields also contain calculations and expressions. The problem that I am having, is that I want to hide most of these fields for the user when they open up the datasheet, however, no matter what I have tried, the...

I was wondering if anyone knew of a way to add two different dates together? I have a Birthday date that I would like to take the month and day from and add it to a Date of Hire date that I would like to take the Year from. Something like this: Birthday 2/16/69 Date Of Hire...

Does anyone know if there is a way to round a calculated field to an even number? I found a "RoundToNearest" formula on the Microsoft support site, but it doesn't seem to work (I might be putting it in wrong). Any suggestions?

Hi, What type of formula could I use in a control source of a field to round/truncate numbers? Thank you!