Search results

I am writing an SQL statement to generate a query and then open a report: ' Run the query and report MyDB.QueryDefs.Delete "qryCustom" Set qdf = MyDB.CreateQueryDef("qryCustom", strSQL) DoCmd.OpenReport "rptCustom", acPreview my SQL statement ends with an ORDER BY statement...

How come when I try to declare a DAO object, the member type 'Recordset' is not there but there are other members? I included the reference for DAO too.

I'm pretty new to Access and I was asked by my department to write a program to store alot of data, which I did already. They want to be able to do many types of reports based on many more combinations of data than I could set as static queries. For instance, we have 25 fields and we could...

I am trying to implement an email function that goes through a query with email addresses and sends a mass email out using Netscape 4.7. Unfortunately, the lab doesn't use Outlook which would allow this code to work. Does anyone know of a way to have Netscape 4.7 Mail work nicely with...

I have a record that is getting data from a qry but I also want to display the total number of records from the table too. I tried this: =Count([tblBnrStudent]![BnrID]) but it keeps asking me for the value of tblBnrStudent!BnrID. I also tried using this: =DCount([BnrID],"tblBnrStudent",???)...

I have a simple if statement to check if a string is Null or not but no matter what the value is, it always skips over the expression: Do While Not rsEmail.EOF If (rsEmail.Fields("email").Value) <> Null Then strEmail = strEmail & rsEmail.Fields("email").Value & ";" End If...

I want to copy my whole db file.. tables, forms, code, etc.. into another db file but when I try to import and then look at the code it gives me an error that it cant find the file. Does the VB code get imported too?

I want to run a query between two tables to see if there is a matching record or not. If there is no record, I have a Yes/No field in the table called "notInSystem" that I want to be clicked YES then. How would I go about this? ex: student table: ID NAME notInSystem 1 Tom...

I want for the user to be able to choose his or her own path for the exported table to go to instead of statically stating it in the code. I know I can have a textbox to put the path in but I want to click on a button and be able to dynamically select the path as you would for example opening a...

Why would the following code say data type mismatch in criteria expression? Private Sub StudentID_AfterUpdate() On Error GoTo Err_Handler If Not IsNull(DLookup("[StudentID]", "tblStudent", "[StudentID]= " & Me!StudentID)) Then MsgBox "Student Record already exists...