Search results

Yes the cancel = true does the same thing, but I tried cmd.cancelEvent just to make sure. It cancels the current event you are in, which in my case is beforeUpdate. But I need to make sure it doesn't start the Unload event, or find out what is changing the records back.

I an adp database that is connected to an sql server. I have a form that lets the user edit records. I want the user to be given the option to save their changes when closing the form. My code does something like this: form_beforeUpdate method () check for changes ask user if they would like...

None show up as missing. I added Microsoft DAO 3.51 object library and I still get the same error in my query.

Let me explain this a bit better. I am using an ADP access database. I am trying to create a query. Just to make this simple lets say there are currently two varibles in the query, AccountNum and Date. I am trying to create a third variable called BranchNum, but its value will vary depending...

I am trying to check the value of a variable in a query. The problem is that the value is in the middle of a string. such as "Account# f2b5" I want to check the very first number of the account because that tells which branch it is from. I tried something like this: CASE WHEN ([AccountNum] =...

I'm really stumped on this one. I have a report that is grouped by student. Each student has a number of scores in the detail section labeled test1, test2, test3 etc. There about 40 of these tests. each student will have anywhere from 20 to thirty of these records that contain 40 tests...

I am trying to take a string from an input box and place it in a table. I was told to use ado. I have tried but it seems to have problems with Access Data Projects. see http://databaseadvisors.com/pipermail/accessd/2003-April/005252.html Does anyone know how to get this to work in an .adp...

thanks that solved the DAO problem but now but the "set db =" is not working. can you provide an example of how to tell it to use the current database?

It isn't finding the DAO object. Could this be because my database is a .adp (Access Data Project)? or do I need to include something in my code?

I have an input box that gets a string from the user. I want to put that string in a table. How would I do that?

ya it was a simple problem. The report wasn't to long, but it was to wide. Took me about 3 min. to notice.

I have a report that I set to "Force new page" "After Section" which it does but it also creates a blank page. The report only takes about the space of a quarter of a page so it is not like it needs to fill a second page for anything. Does anyone know what might be the cause?

got it working I got it working, I just created a simple query of the student field in the data table. Then I right clicked on the item in the query design view and selected properties. I then saw a check box for SELECT DISTINCT. I checked it and it seems to be doing exaclty what I wanted...

Here is the problem, I have a table with student names in it (as a primary key) there is another table that contains the students data. In this data table the students name is also listed, but not as a primary key, so there are many copies of a single name. What I am trying to do is open a...

Solution I found that this worked: If DLookup("Student", "DataTbl", "Student = '" & Me.Student.Value & "'") > 0 Then

this is what I have tried: If "SELECT [DataTbl].student FROM [DataTbl] WHERE [DataTbl].student] = '" & Me.Student.Value & "' " Then I want it to execute code if there is a student that has the same name as the variable.

so how would i put that into an if statement?

I want to write an If statement that will, for example: check table1 to see if any records in field1 are equal to a variable. Does anyone know how I would go about this.

it doesn't allow new records to be created

I have a form that allows the user to edit data, but it only displays records of one student that the previously selected. The user is able to edit the student name. When they do this the student will no longer be displayed on the form since it does not meet the criteria of the student that...