Search results

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...

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...

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?

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?

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...

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.

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...

I want to check data before it is saved. I am using the before_update method to have it check the data and will use "cancel = true" to stop the save process if the data does not pass through my criteria. The problem I am having is that when the user tries to view the next record it will go to...

I have a button that is set to delete a record. when it is clicked it asks the user if they really want to delete the record, If they say no it then proceedes to pop up a dialog box that says "The DoMenuItem Action was canceled". I would like to be able to catch this and replace it with my own...

I have a lot of modal forms in my database. The problem is that when I open a report the user can't do anything with it until the form is closed. Is there any workaround that would allow the user to view the report and when they close it have them go back to the modal form?

I am trying to open a report that only will show records that meets certain criteria. This is in a .adp database and I am having some trouble with it. I tried creating a macro and defining a where caluse of: [Student]=[Forms]![FrmSubStudent]![Student] and...

This should have a pretty simple answer. All I am trying to do is open a report and throw multiple where clauses at it. I am connecting them with "and" and it seems to like the syntax but as soon as I run the macro from the form button it chokes. I've triple checked my form names and control...

Ok I know that this question is a really simple one, but i've been fiddling with the code for about 10 min and haven't found a solution. I am trying to make an if statement with many or's in it. Here is the code that I have been trying to get to work: If ((Test1.Value Or Test2.Value Or...

I am trying to do something that I once knew how to do, but time and lack of using access has got to my memory. What I need to do is have a combo box that looks at a table, I want its rowsource to be column 1 of the table and the record I want recorded is what is in column 2. Basically column...

I am having a problem with my forms. They are being used for data entry they have allow edits, allow additions, and data entry all turned on with a recordset type of updateable snapshot. When I try to add an item I getting some error messages. I can't figure out what is causing them, they...

I have forms that are trying to save when they are being closed and with null values it displays an error message. I want to stop it from saving when closing the form. Normally this wouldn't be a problem I could create a custom button that closes the form without saving using a code such as...

I have a textbox that I want to check for the keypress event. It does as I ask but the key I am checking for is the enter key (otherwise known as vbKeyReturn) when i hit the enter key in the text box the keypress event doesn't run and it changes its focus to the next item. Is there a way I...

I have created a program in vb.net that creates a sql database. I know need to open that database with access on a pc for user friendlyness. I have seen many programs that can take an access database and turn it into an sql database but I haven't found a way to turn an sql database into an...