Search results

Thanks for the tip. Its seems to be working now. Since you are familiar with SQL maybe you can also help me with another problem I am having. Say I have a form and it is adding data to a table with one field and that field is the primary key (so no duplicates are allowed) now if i open access...

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

Solution Private Sub Form_BeforeUpdate(Cancel As Integer) If Class.Value <> "" And TxtLName.Value <> "" And TxtFName.Value <> "" Then Cancel = False Else Cancel = True End If End Sub Private Sub Form_Error(DataErr As Integer, Response As Integer) If DataErr =...

ok i have fixed on of the error messages from displaying by using: Private Sub Form_BeforeUpdate(Cancel As Integer) If Class.Value <> "" And TxtLName.Value <> "" And TxtFName.Value <> "" Then Cancel = False Else Cancel = True End If End Sub so access no longer...

Access is not saving its data locally it is saving it out on the SQL server.

The insert wasn't for the sql server it was for the form itself so it could only stop things from being inserted into the form itself and not into the sql server.

I found that it does stop at beforeInsert() is there any way to stop the insert from occuring so that I can manually insert the new record only when the form is completely filled?

I tried using the beforeupdate method but the problem is that is doesn't ever run. I forgot to tell you that the database is a subscriber to an sql database, that is were I am getting the Null error from when I try to close the form. Any other ideas. I've tried numorous methods but none of...

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

problem solved I solved the problem my going to tools --> options ---> keyboard tab and changing the action of the enter key.

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

This looks like it may help. It looks like I have to send the database from the pocket pc database (sql server ce) to the main desktop side (sql server 2000). Is this correct? When I clicked to select a server it gave me two options, BETA and COMET. I am on the company's network so I am...

sql server ce Sorry for the cofusion, I created the database on a pocket pc using SQL Server CE.

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

thanks I should've known it was something so simple. Thanks

Does anyone know how to change the text in the title bar, so that you can put your own text in the title bar for each form. I thought I saw it somewhere once before but now I'm having a hard time finding it again. I tried going to options startup and editing that but that is the same for every...

It works great Thanks for the tip. I would have just changed the background color but it is also an image. It was actually a wordart image that I was trying to insert so I wasn't far off to start with but it was doing weird stuff to the wordart picture quality when it loaded it. So I took a...

I am trying to put a transparent GIF image into an access form but it keeps putting a white background on it and when I tell it to make the background transparent it makes a new layer in the way back of the image behind the white background and makes that transparent. Anyone now how to fix this?

It works, but there is still a problem I have got it to work the way I wanted it maybe even a little better than I was expecting, I had to add 3 new queries. I am having another problem now which I have already posted on the forum but have had no luck solving, you can view it here...

I have a database that hides all toolbars on startup. I want to create a macro to show the toolbars for troubleshooting. I have the vba code to do so and I named a macro AutoKey with ^q in the name of the macro, but now I want to assign an action in vba code, I tried exporting the mostly blank...