Search results

Something is still amiss Previous: DMax("Odometer","tblOdometer","[Odometer] < " & [Odometer]) SELECT qry_ODO_Table.ODate, qry_ODO_Table.VehicleNum, Nz(DFirst("Odometer","qry_ODO_Table"),0) AS StartOD, qry_ODO_Table.Odometer, DMax("Odometer","tblOdometer","[Odometer] < " & [Odometer]) AS...

You're right, that's what I want. I guess I'm asking which part makes the underlying table read-only. Like you, I have the save button set to insert the records in the table, just using a different command. Perhaps It's something on my form itself thats causing me to be able to edit the bottom...

I'm a little unclear on how to use it to "get the previous odometer reading" and make it get the "odometer reading is less than the current record" in the same statement, if that's what you mean. To me, it sounds like it should be two separate statements? Previous...

I recently posted a question regarding this query, but in going back, I need a different kind of total. I am looking for a way to get a progressive cumulative total from daily entries on Odometer records from multiple vehicles. (My current SQL query is not working) I will eventually run a...

Hmm.. To me, it sounds like it's the same setup. I attached the form and here is what I use for my save button control Dim DB As Database Dim rec As Recordset Set DB = CurrentDb Set rec = DB.OpenRecordset("Select * from tblBlotter") 'test required fields If IsNull(Me.txtEntryDate) _...

hi I attached a screenshot for your review. The top of the form shows controls where the user will enter data, which then appear in the below part of the continuous form. ( It is not a split form). Also, the top controls used for data entry are unbound if it makes a difference. Currently, I am...

I have a continuous form with unbound controls. These controls write new records into a table using rec.addnew If possible, I would like for the user to only be able to add/edit the new record only and not to edit the continuous form below. When I turn off edits on the form, I only get the new...

Im really not sure. Im was afraid to touch the SQL code, someone helped me on it from another thread. Or it could have been me trying to get it working with the new control type or during a copy paste got carried over. I saw that the checkbox wasnt enabled on the query, but still thought it was...

:) That was it. You wouldn't have any idea why I am getting two separate line items on March when I run this query for year 2014 would you? I attached a sample.

I had to modify how I was storing data on one of my tables. I changed checkboxes to an option group with the values ranging from 1 to 4. I need to count each of these entries for a report which will run them into another formula. I am trying to use the below - obv I'm doing something wrong...

Wow.. Definitely much simpler and easier to keep up with. Thank you

Looking at DSUM now. Here is the sample

Hi, I am having an issue with my running total query. It consists of a running total per vehiclenum. All data comes from one table. It works properly only on the first vehiclenum of the query. After that, the first "previous" odometer reading of each subsequent vehiclenum starts at some...

Simple question but I can't find the answer: I have a continuous form which I created using the wizard. The form has three fields: VehicleNum, ODate and Odometer. In the header of the continuous form, I changed the VehicleNum to a combo box that filters my the form by VehicleNum. (So it...

Not Report preview. Just open the report as a PDF. I can do it with excel but can't get it to just "preview" to PDF without saving a copy of the PDF somewhere. On another note, if that's not possible, would you know how I could add code to my vba somewhere to remove the PDF file once it's...

I have a report based off a query. Then I have a report to just format what I want the data to look like. All I want to do at this time, is be able to open a PDF instead of the report - if that makes sense. I dont want it to prompt them to save it and I dont want to have to specify a path. I'm...

I have some code below that exports a report to PDF. It works fine, I just want to know if it's possible to export the PDF without saving it? I can't seem to find anything on my search about it. 'Open Report From Query DoCmd.OpenReport "rpt_BLT_PrintReport", acViewPreview, Me.Filter 'Output...

Is it possible to copy an Excel Macro into Access? I would assume the VBA code is the same? In access, I already have some code to export info from a continuous form by calling a public function. Public Function Send2Excel(frm As Form, Optional strSheetName As String) ' frm is the name of the...

Uh oh - well, works mostly works... cboBadge (combo box) works when filtering by itself or with txtResponse (string), but it does not work with the txtStartDate and txtEndDate filters...?

By chance would you have any idea how to run a report based off the remaining records on my continuous form?