Search results

Hello, I have searched and followed many of the suggestions in the forum and have gotten to the point where I can send a query via email. The only thing I need to complete this project is the abilty to add a specific date to the end of the file name being sent. Specifically, I have a query...

I have a process in Excel that I need to migrate to an Access2003 database. We need to calclulate a percentage of the value of a Part# based on how long it has been in Inventory. The table I have contains GroupType, Part#, Value, ReceiptDate. In excel I have a matrix with 6 GROUPNAMES down the...

Hello, I have created a database to track onhand inventory. I am having a problem with appending data from one table to another. When I try to create the append query the destination table does not appear in the dropdown list of tables to append to. The destination table GROUPSLOOKUP contains...

Hello, I have a form and subform, both based on a separate query. The box I created to show the total of the datasheet subform is working correctly in that it does show the correct results as I expect. My problem is that I can not get this total to show on the main form. I have been through...

Hello, I have a form used for data entry purposes and the numbers entered must always be negative (to show a credit). I searched the posts and found information explaining to use =Abs([Freight_Credit_Value])*-1 in the control source of the control. I thought I did that but it still doesn't...

I have a database of freight invoices that I need to create a crosstab query to see the month the invoice was paid compared to the month of the invoice itself. The problem I have is the month the invoice is paid (INVPAID) is not the calendar month but a custom fiscal month. For example...

I need to test a field to determine if it has a 7 digit number combination that begins with a "10", 20", or "80' and if it does, return that 7 digit number combination. A function to do this would be great. Is this possible?

I have two tables, Invoice and Frt_data. The two are linked using two fields (Customer_number and Process_date). I need to enter the month name in the 'AP_month' column of the Frt_data table based on the Invoice_nbr in the Invoice table. I created an update query containing the fields...

Hope somebody can help with this. I checked the archives but not luck. My continuous form allows entry of 12 records. On the thirteenth record the new row scrolls to the top and all the previous rows disappear. Every new record after that scrolls up out of view and a new blank row is at the top...

Hope somebody can help with this. I checked the archives but not luck. My continuous form allows entry of 12 records. On the thirteenth record the new row scrolls to the top and all the previous rows disappear. Every new record after that scrolls up out of view and a new blank row is at the...

I have a query based continuous form that looks up a serial number entered by the user and allows them to view the matching data. When a user enters a serial number that is not in the database I want a message box to pop up to warn them there is no match. The code I am using makes the msgbox...

Hi group, I am a newbie to Access and VBA programming. My original post was probably not very specific as it was not answered but I really need help on this! TABLE1 stores a list of serial numbers and a status field (it contains the word Pass or Fail). The NEWSN table is used to capture new...

Hello group, I am a newbie to Access and VBA programming and have been struggling with a few problems I am sure is simple for this group to solve. My database has two tables: 'Drive Test Results' containing SERIAL_NUMBER, DATE, TIME and RESULT fields among other data; 'Packing Station Scan'...