Search results

I have a form (frmState_Mileage), where a truck driver enters the odometer readings (M_Odom) for each leg of a trip. The form assigns a unique number (M_SerNo) to each leg's record, when a driver starts a new trip or continues on the same trip All records are saved in tblState_Mileage...

Is it possible to incorporate VBA in a report to send record's picked field's data that is displayed to a form. If so, please show me an example(s)

Using Access 2007 (I know). I have a form with a text box, where I can enter various commodity names. I want to pick a command control that contains code the sorts through a query for all records that match the name entered into the text box and open a report that displays them. I have already...

I have a form with an unbound combobox that has a manually list of integers that represent trip numbers - T_TN). When a user picks a number from that list, it executes "After Update" VBA that opens a report containing all information pertaining to that trip. Within that VBA, I have VBA statement...

I tried several suggestions that I was able to find on the 'net, but none of them cleared the clipboard. I am aware of the manual method, but would like to know if anyone has be successful using VBA, like using a module that can be called when forms load, for example. Thanks in advance.

This code works fine to file a year's profit & loss spreadsheet. Tried to get it to work correctly to use the same queries, but only to fill months Jun thru Dec for 2018, in columns B-G. Then, for 2019, I'll use the same code in 2019's db to add months Jan thru Jun in columns H-M to complete...

Re: Reports displaying multiple records Thanks for the opportunity to send my db. Have a good laugh at my code. It's alright. After "we' solve the multiple display problem on the reports, the next and final hurdle is to combine the trip sheet & fueling report on a single page. This post was...

I submitted this earlier, but didn't receive any response(s). My Access 2007 table holds 25 groups of trip records. The individual group records are sequentially numbered trip leg record sets, such as: 1.01, 1.02. . .etc. for the for as many legs for the first group, 2.01, 202...etc. for the...

My Access 2007 table holds 25 groups of trip records. The individual group records are sequentially numbered trip leg record sets, such as: 1.01, 1.02. . .etc. for the for as many legs for the first group, 2.01, 202...etc. for the second group and so on for all 25 groups. Objective: Select any...

I have a report that displays correctly. as a single report. When I use the subreport wizard or drag the 'good' report onto the body of the main report, all fields display correctly, except the column header for the subreport is missing. Here is where the wizard placed the subreport...

Having a lot of trouble designing a report with a subreport. First Issue: Initially, i want to know if I am formatting it correctly. Here is what I have: Report Header - - Holds the main report title; Page Header - - - The control header column names for the main report; =========== Detail - -...

Access 2007: I have a form with a combobox that is configured as value list. I want to pick a trip number (ie., D_TN) from the list, like trips 1 thru 10, and open a report. I, also, have a query that contains the leg numbers for each trip, like: 3.01, 3.02, . . . . 3.05., which are all under...

I have a memo that I want a user to be able to 'show/hide', when a user opens it again to enter a new record's data or to view the memo for all older forms containing data. I can show & hide the memo using a control on the form to toggle the 'visibe' property with vba. Not knowing any...

Google didn't have anything on this. So, I'm here asking the forum this question: Can an Access 2007 db report have two headers on the same page? My customer has asked me to create a single page report with two separate headers: one with 6 columns of trucking trip travel data & one with the...

Looking for some suggestions to enable me to write some code, for when a control button on a form is pressed, that will match, for example, 5 numbers that I pick with 5 winning numbers that the lottery draws AND save how many of the numbers match. (I know how Excel is an easy way to do this...

I asked for help about 2 weeks ago, received some help,but no solution to my problem. So, I trying another approach. I have a control on a 'L_Name' customer's form, in an Access 2007 DB, that copies a template Excel file (ie., SOM.xlsx), renames it to 'L_Name SOM.xlsx) and fills it with...

I have seen the following 'set' statement in an example of VBA code: 'Open in the read-only mode Set src = Workbooks.Open("strFolder_PathNew ", True, True) I was unable to find any explanation of the significance of the two 'True, True' ending the statement. I would like to know what all four...

I have a control on a customer's form that copies a template xlsx file and fills it with customer name, address, etc. While it is open, I want to copy a cell's value from one xlsx file and paste it into a cell on the open xlsx file that I just created. After trying various suggestions seen on...

My code to carry some fields of a form to a new form and clear selected fields. It works, except for one combobox field & one text box (Me.Driver & Me.Material), whereas the other combo, text & date fields do work.) I've tried doing everything for a month before giving up and asking you experts...

Code to use start & end date entries and cbo selected item to open the related report I have a form with a startdate & enddate fields and a cboExpense_Selector. Need to fill start & end date fields & pick an expense item from the cbo and open a report that desplays the expense for that item for...