Search results

OOPS... I'm still having a bit of a problem. I'm receivng an error: The data has changed Another user edited the record and saved the changes before you... Re-edit the record. -- OK If I click OK it works fine, nut I'd rather not see the error I tried coding DoCmd.SetWarnings False but no...

Excellent, Thank you very much. I think I got it. I'll keep you posted if things start to bomb. Thanks again, SKK

I understand that. However, being the dummy I am, don't know how. Any suggestions would be greatly appreciated. Thanks, SKK

OKAY here we go. I attached a small sample of the database (the entire DB zipped is >3MB). I only included items needed to demo my problem relating to Permits. 1. Open Sidewalks DB 2. Click PERMITS tab 3. Click View/Edit Permits 4. There are three records in the tblPermits table. Note the...

You made me think more closely. I believe I may have looked at this wrong. Rather than an UPDATE I believe this should be an Append (Insert Into) query. Until I ACCEPT my frmAddress, there is nothing in tblPermits (although the record does exist). Is there a way to set my WHERE clause to...

Thanks. Let me play with this a bit and hopefully I'll get somewhere. I'll keep you posted. Thanks again, SKK

I'm sitll having a problem. I'd like to explain a bit more in detail what I'm attempting to do. This is quite a detailed database with numerous things taking place. The primary concern is sidewalk construction inventory. There is a tab control with numerous options of which one is PERMITS...

ParID is not the primary key (Record_NO is) however, it is a text field. I'm assuming I need some other quotes.apastraphies? Thanks, SKK

I know this gets a bit convoluted but here it goes… I’m having a problem with an SQL update query. I want to update the ParID field in tblPermits from frmAddress where a lookup field PIN has the correct data. Upon clicking the “Accept” button in frmAddress it should insert the correct ParID...

Sound fine. Thanks again John... Talk to you tomorrow, SKK

John, Thank you very much for you concern. I believe I have a work-around. I created a command button (cmdGIS) with OnFocus coded as SendKeys “{Enter}” and the OnClick with my requirements. Once the Address button looses its focus, it goes to cmdGIS which in turn runs my requirements. I...

When I requery, it returns a blank form (in ADD mode). I also tried (with same results): Forms!frmGrades.Form.Recalc Forms!frmGrades.Form.Refresh Forms!frmGrades.Form.Repaint Forms!frmGrades.Form.Requery SKK

Hello, I have frmGrades with a command button that opens frmAddress based on a query that selects records per key-in. When frmGrades is opened in ADD mode, I open frmAddress to find parcel number (ParID) that corresponds to the keyed in address. ParID is then inserted into tblGrades. This...

Ahh, I think we're on to somehting. However, this form was opened in acFormAdd mode. When I run the Me.Requery it closes the form (which I understand it would). Do you think there is some other way I could update the form without closing it? SKK

Hello, I’m trying to update one table based on data in a second. As a test I have setup a simple Data Entry form with two text boxes (txtGIS_Ownername & txtParID). Its record source is a select query linking GIS and tblPermits tables by the field ParID. Ultimately I want tblPermits updated to...

I just noticed that. Thank you, SKK

Disregard for now - I think I got it. Needs a bit more testing but so far so good. SKK

Hello, I have a frmGrades based on a query that displays all records. I want to add a command button to the form that when clicked filters the data to a set criteria – something like Me.Filter = “[ReceivedBy] = ‘SKK’” I tried coding the forms OnOpen with Me.Form.OnFilter = False then coding...

Thank you very much. I have another app I can use this on. Will look at tommorow. Greatly appreciated, SKK

I may have answered my problem. Here's what I've got now. Dim objNetwork As Object Set objNetwork = CreateObject("Wscript.Network") On Error GoTo Err_Handler objNetwork.MapNetworkDrive "K:", "\\ce_laptop2\sidewalks" ' --------------------- MsgBox "YUP - Laptop's there..." GoTo...