Search results

Good morning - Is it possible to have a query that will requery value of a check box based on which check box is selected? I have a form that has 5 check boxes and a text field for populating a unit price. When someone clicks a specific check box, the text field should display the unit price...

Hi- I wanted to know if it's possible to open a form in another database based on login? I am setting up multi-user front end forms on a server into each user folder. The main form contains 2 drop down lists to select report and site name. Once the click submit, login screen appears. After...

Hi- I need to daily import files that start with same name, but the remaining part will be Bill of lading ID (e.g. TEST_BOL 1234.csv). The next day will be TEST_BOL 1235.csv) and so on. I need for Access to import the file based on the "TEST_BOL" into my database and then delete the file from...

Hello- I have a database that calculates totals on entry forms and reports. Sometimes when entering data or generating reports, the total fields, which are not associated to a table, will be blank, however the data from the tables will display. The total fields I have are for display purposes on...

Hi- I have a report with command buttons to export to PDF when pushed. However, I need to include script to read if data from another table exist with client ID that equals to client ID on the report, then a message box will instruct them they need to clear out data from table before proceeding...

Hello- I have an export query that has number of distribution and CM distribution for invoices generated. The objective is to count the number of invoices based on the account number for each customer ID. Since the table has no primary key, the I assigned field number of distribution to 0 in...

Hi- I have a table that will have ITEMID as unique field but location could have save values. I tried using DLOOKUP to look at the value for the previous record to see if I need that value is same as current, however, since my data query are text formats, I am unable to. I get a message of...

Hi- I have a simple form with a combo box linked to a field on a query and command button with vb code to open a report based on the value of combo box. The command button also includes code to requery the value of the combo box so that what was already generated in the report will not display...

Hello- I have a query that pull data from hours worked fields that have values with decimal places. Hours is multiplied to rates to create my amount to charge in my query which is then displayed on my invoice report. The issue is that when I sum my amount, my subtotal is off by $.01 due to the...

Hi- I currently have 1 form linked to 1 table which data from another table is appended to for editing, re-appended to original table and then rows are deleted. However, this process will need to be done by 4 other users soon and I needed to know if I need to create 4 separate tables and 4...

Hi- I have 3 combo boxes for selecting clients, start and end date ranges. I created an indicator to flag true if I have used a start and end date. However, i need to include the client combo box as well. The process should be select client, select start date, select end dates. Restriction...

Hi- Does anyone know how to have a csv format with the fileds of date to display only my date field instead of datetime field? I tried CDATE and when I review my output, the format is still datetime. This export is from within a query I created. Thanks- anissw

Hi. I have multiple conditional statements in order to define Quantity and Access only allows 255 characters for the expression builder. How do I setup my function to define quantity based on the multiple conditional statements I need to implement? The quantity field name I have is based on...

Hi. I have a table that I have created for generating invoices. My program and codes work, however, I need to include a row counter for the invoice table. So far, when I initiate a count using DCount, it will generate the count of total number of records, (17 records in a table for each record...

Hi. I have a form that have 2 combobox for date value ranges (CboStartDate and CboEndDate). My query generate order based on these dates ranges with no problem. I need to have 2 fields created in my query (WeekBegin and WeekEnd) with the values from the combbox start and end dates. So far...

Hello- I'm trying to open a report from a button on a form in preview mode. When the report opens, the option to close print preview, pdf or xps, etc on the top nativiation pane is locked not allowing me to export to a PDF, change orientation, or print. I have to go to Window and then select it...

Hi- I have a query to append new invoice records to a table I name master Invoice. I am having problems getting this query to look at query CustomerDetails and only append records that do not exist in Master Invoice. I have included my query below. This query with the criteria included will not...

Hi- I have created user defined function for lastdayofweek, lastdayofmonth, and firstdayofmonth. When I apply this function to an expression in my query, it returns a julian date. How do I apply the format for the calendar date? Maybe I am not calling my function correctly, so any help is...

Hi I replied to post of Exporting to the same XLS file on 1/4, but didn't receive a reply. I need to export out from one table to Excel grouped by client ID to each worksheet. The Excel report will have approximately 15-20 worksheets. The DoCmd.Output exports each client to their own...

Hello- I have created a database and report to summarize specific total returns in a week. However, I would like change this so that the user can select from a dropdown the parameters in question from 3 combo boxes on a form. I was able to create the form, setup the combo boxes to pull the...