Search results

Sorry. Still doesn't work.

I am trying to open a child recordset but keep getting Error 424 "Object required". Dim rstEmails As DAO.Recordset2, DBS As DAO.Database, rstFile As DAO.Recordset2 Set DBS = CurrentDb Set rstEmails = DBS.OpenRecordset("Beldenemails") Set rstFile = rstEmails.Fields("email").Value 'Error...

Strange as this may sound, the ADO method "Clone" returns a DAO recordset. You have to use FindFirst instead of Find.

There is no Recordsetclone property in ADO. You have to use the Clone method instead: Dim rst As Object Set rst = Me.Recordset.Clone

You can't use the Like operator in a Select Case statement. Try this: If InStr(strType, "Arterial") > 0 Then strType = "Arterial" ElseIf InStr(strType, "parkway") > 0 Then strType = "Parkway" ElseIf InStr(strType, "expressway") > 0 Then strType = "Expressway" End If

Access makes a guess as to data type by looking at the first 5 or 10 records. What I would do is add another now to the spreadsheet, just under the headings, and put an "x" in each of the used columns. Then, when you import into Access, all the fields will be text and your field names will be...

You can create a query that returns a unique list of all student IDs that have term addresses. Using the ID field, join that query to the full list to obtain a unique list of IDs that have no term address. Then you can use a join query to put both lists together.

Just occured to me. In your screen shot you have two other entries in the grouping and sorting dialog box between the two entries for your date. It's sorting the header/footer by the month, then the detail section by the other two fields first then, lastly, by the date. Move the second date...

Just occured to me. In your screen shot you have two other entries in the grouping and sorting dialog box between the two entries for your date. It's sorting the header/footer by the month, then the detail section by the other two fields first then, lastly, by the date. Move the second date...

It looks like it should work. If you want to send me the database - table/s (structure only), query and report I will take a look at it: c_pod@hotmail.com

You need to list your date field twice in the Grouping and Sorting dialog box. Once to establish your group header/footer and once to set the sort order.

You could just add a new date field to your table and then, in a query, use something like this to update the new field: DateValue(Left([textdatefieldname],3) & "01/" & Right([textdatefieldname],2))

Try this: Me.Recordset.FindFirst "fldLastName Is Null"

You can use a little Visual Basic to put the value into another textbox on your form and then call for the value in that textbox in your query. Add another textbox to your form (It doen't have to be visable. You can turn the visable property to false in the textbox's property list). In...

Just use an expression like this in your maketable query (filling in the name of the form that has the text boxes and the name of the textbox were indicated): : [forms]![NameofYourForm]![NameofYourTextBox].[value]

If you give me your email address I can send to a small database to get you started.

=DLookUp("[rap_planned_time].[calculated_time]";"[rap_planned_time]";"[rap_planned_time].[customer_id]= [customer_id]") What you are telling Access to do here is find a customer_id that is equal to the string "[customer_id]". Not what you want. The variable expression in the criteria must...

Try this: if isnull(me.rec_qty) then me.rec_qty=0

Just remove the property references: if me.rec_qty="" then me.rec_qty=0

OK. You can use something like this: Dim intFileCount as integer, fs Set fs = Application.FileSearch With fs .LookIn = "C:\yourdirectorypath" .FileName = "yourfilename" intFileCount = .Execute End With If intFilecount is greater than 0 then the file exists.