Search results

Hi folks, I have a report run based off of a query. If I run the query directly, it loads in about 5 seconds; however, if I run the report it takes about 10-15 minutes to load and is only 3 pages long. The query contains first entry/last exit times for employees filtered by date. The report...

Hi folks, Looking for a little help here. I have a form that allows my users to select a customer from a list and inputs that customerID into whichever parent form they call it from. This works fine for 90 percent of my forms, however, I am getting the following error on one form: The body of...

Hi folks, So I have a subform whose 'Link Master Field' property is set to my listbox, 'lstMachines'. When I click on an item in the listbox the subform automatically updates to reflect the child records. However, when the items are updated in my listbox I use vba to select the first item in...

Hi there folks, So little issue losing a form here. Here's the setup: - I have a parent form bound to a parent table with a subform bound to a subtable. - The parent does not allow data entry and has its sole field filled by a listbox. - The subForm is a data entry form which contains two...

Hi folks, So I decided today that I would attempt to minimize the number of forms that I use by using the same form for entry and review. Fairly straight forward, just turn allow additions on when the user uses my custom nav buttons or enters a customerID that already exists. However, I would...

Hi folks, So I solved an earlier problem loading a specific record and now found myself with a new issue. While my code opens the correct form on the correct record I find the form opens without properly drawing boxes, lines, and the record navigation pane. If I move drag the form off the...

[SOLVED] GotoRecord 1 and 2 mixup Hi there folks, Little trouble here. Probably a simple thing that I'm overlooking. I was using the following line of code in the double-click event of a list box to allow users to navigate a form to a particular record: DoCmd.GoToRecord acDataForm...

Hey folks, Not entirely sure whats going on. I keep getting the 'variable not defined error' in the following code: Sub Aggregate_Click() Dim MyPath, MyFilename As String Dim vNames() As Variant Dim i, intSheetCount As Integer If Worksheets(1).Cells(14, 15).Value = "1" Then intSheetCount...

[SOLVED] Variable not Defined: Sheet and/or Worksheet Hey folks, Not entirely sure whats going on. I keep getting the 'variable not defined error' in the following code: Sub Aggregate_Click() Dim MyPath, MyFilename As String Dim vNames() As Variant Dim i, intSheetCount As Integer If...

Hey folks, So I have a raw data dump from my server which unfortunately uses two rows for each record, with the second row containing data in only one cell. The cell above this one data item has a useless piece of data which i would like to replace with it. Currently I have the functionality I...

Hi folks, So I've been looking around both my code and online to see if I can figure out whats causing this little irritation. I have a form with a tab control with a subform on each page. The subforms are continuous and display subtables to the master record held on the main form. If the...

Hey folks, So access doesn't take outer joins I take it. I have three tables. tblGuidelines which contains the primary key pedGuide tblCourseRecords which contains a list of courses with the primary key courseRecordID and tblCourseRecordPedMarking which is related to tblCourseRecords...

Hi folks, So I'm trying to combine data from 4 tables, but to start im just trying to make sure my joins are set up properly. The idea is to have all the rows from the first table regardless of whether data is present on the other tables and join the other tables where there is data. So...

Hi folks, So now we've having tons of fun. The folks here need to be able to add, edit, and remove records which relate to pedagogical items on a whim. There is no scenario where the number of these items will ever exceed 75. These items are then used to create table columns on a separate...

Alright folks, So I haven't spent much time i the past modifying recordsets with vba so I'm off to a slow start. I've been looking around and I'm still having trouble with the navigation. I have a listbox(lstGuidelines) which contains the records from a record set. The first column displays...

Hey folks, So I'm building a query for export to excel based on user filters and so forth. It was working dandily, until I threw in some code to replace field names with values from another table. Now rather than look for problems with the vba, i'd like to figure out what the hell is wrong...

Hi folks, So I have the following code: Private Sub lstGuidelines_AfterUpdate() DoCmd.GoToRecord acDataForm, Me.Form.Name, acGoTo, Me.Form.lstGuidelines End Sub Works like a charm when I load up the form. However, when the same form is embedded into my main interface form I get the...

Hey folks, Does anyone have any resources on form planning? I keep revising my forms to make them more streamlined and then I discover new features that demand reorganization. Right now I'm trying to determine the best way to build a form with Add/Remove/Edit capabilities with an efficient...

Alright folks, It's been a while, I hope everyone is well. This is a stupid error that I am hoping is due to some small oversight. I've simplified the process just to minimize that chance. Here goes: Private Sub Form_BeforeUpdate(Cancel As Integer) Cancel = True End Sub I have several...

hi there folks, So after not touching Access for a year and a half I feel like I've forgotten everything. So please forgive me for this: I have the following SQL string: SELECT courseID, SUM(num_labreport * enrollment * (SELECT estimatehrs FROM tbl_guidelines WHERE itemindex = 1)) as...