Search results

I have built a database for a client which they have been using for quite some time. Recently they had some sort of issue which prompted them to uninstall and reinstall Office 365 on their machines. Unfortunately, they installed the 64 bit version and the database was built using the 32 bit...

I have a main form (frmMain). Inside frmMain is a subform (frmSub1) in Datasheet view. Inside that form is a form (frmSub2)in Continuous Forms view. It looks like this: On frmSub2 is a control called "Unit". I want it took look up the value in the "Unit" field in tblData where Category =...

I would like to use the DMax function to find the maximum value in a field [YearNumber] in a table [tblData]. The values in the [YearNumber] field are formatted as follows: AA19-001 BB19-002 CC19-003 BB19-004 etc I would like the Dmax function to exclude the first 2 characters and only...

I recently found some code that will generate a value or ID based on the last 2 digits of a year field followed by a 4 digit sequential serial number. Here is the code: Private Sub Form_BeforeInsert(Cancel As Integer) Dim vLast As Variant Dim iNext As Integer vLast = DMax("[YearNumber]"...

I built an application using Access 2016. The version is: 2016 MSO 16.0.11029.20045 32-bit. I installed it on a client's machine which is running Access for Office 365 MSO (16.0.11029.20045) 32-bit I had to reconnect some linked tables and noticed the Linked table manager on the client's...

In the footer of a report, I have 3 text boxes, txtIncome, txtExpenses and txtPercent". txtExpenses is a calculated control which refers to a text box in the detail section which gets its value from a subreport. It is formatted as currency, 2 decimal places txtPercent=...

I have a a form with many calculated controls on it. The form works perfectly. I recently split the database into front and back ends and installed it on a client's network. The front end is installed on each user's pc and the back end is on the server. However, when the users open the...

I have a report that looks perfect when opened with acViewPreview. I have added a button to the report so that the user can print directly from the report. I have also added a 'Close' button right below it. I have set the 'Display When' property of both buttons to 'Screen Only' so they won't...

I have been pulling my hair out over an issue where a form and report are not giving me correct info when determining if one date field is between 2 other date fields. :banghead: I thought my database had become corrupted but I can actually duplicate the behavior in another database. I have...

I have a main form, frmItemDetail. This form has a subform frmStageSub in datasheetview. Nested within this form is another subform called frmCategorySub in Continuous Forms view. See attached pic. On the main form, there are 6 calculated controls, Dsums, Dlookups etc. frmStageSub and...

I want to calculate a total in a report. It seems to me that a DSUM field would work perfectly, but I absolutely cannot figure out the syntax. I have a table called tblLabor with the following fields ProjectID, LaborID, LaborDate, Total This is working. It gives me the labor total for a...

I have a main form called frmItemDetail. Inside frmItemDetail, I have a subform called frmActivity. Nested within frmActivity is a subform called frmCategory. frmActivity is linked to the frmItemDetail by ItemID and frmCategory is linked to both its parents with ItemID and StageID and things...

I have a form in single form view, called frmProjectsNew. On that form, I have a subform in datasheet view, called frmIncomeSub. Nested within frmIncomeSub, I have another subform in datasheet view, called frmExpensesSub. Both subforms are linked properly with Master & Child fields. On the...