Search results

I’m having a problem with the SendKeys command. I have an older Access 2003 routine that I have been using for years running under Win7 that does exactly what I want. However, I have moved it to one of my Win10 machines and now bombs on one small function. I have my UAC set to Never Notify...

Hello, This may be a bit confusing but… We have a database (CardFile) that tracks plan files. There is a command button on a search form that after running a select query, opens the corresponding file. In most instances this works fine, except when attempting to open PDF’s on one machine...

Hello, I have a form (record source qryPermits) with a field (NoticeID named txtNoticeID) that seldom but under certain conditions may contain duplicates. If so, I want a prompt to appear so the operator is aware this is a duplicate entry. I assume I code something on the control’s AfterUpdate...

I’m trying to open a form based on different queries. I have an initial form (frmFlush-NS) that prompts for N or S (north/south). If I keyin “N”, I want frmFlushMH to open based on qryFlush-N; if an S is keyed, I want it to open based on qryFlush-N. I realize I can do this if I set...

I have a table that I would like to add an AutoNumber Record_ID field to. However, I want the records to be number in a specific order based on a third field called ORDER. I tried alphabetizing the table based on ORDER and saving. I reopened the table and it is in the correct order. I...

I have some VB code I modified to add functionality to an older CAD routine (originally written by a consultant). The new code works fine and appears to do what I want. My question is, not being a programmer, I’m sure I did this quite primitively. I was wondering if anyone could peruse my code...

We have a database tracking construction plans. In most instances the plan number is a 6 character value displayed with hyphens: Display = 98-12-17 Field Value = 981217 I have a search criteria set as: =Left([Plan_No],2) & Mid([Plan_No],4,2) & Right([Plan_No],2) This works fine as long...

I’m looking for a way to open a SubForm from different command buttons on my MasterForm where Button-A opens the SubForm with the RecordSource = Query-A, Button-B opens the same form based on Query-B. Query-A is a simple select query. Query-B is basically the same query with the addition of a...

I have a cmdTest button in frmPermits where I’m attempting to update the Contr_Contact field in tblPermits from data in tblContractors “Contact” field. I need to update (or insert) the data rather than simply linking it to tblContractors as we need to keep the history of who was the contact...

I’m trying to check if data already exists in my table. I have a couple fields that in rare instances could contain duplicate entries. However, when this is about to happen, I want to prompt the user of such. Any suggestions would be appreciated? Thanks, SKK

In most instances, when tabbing through a form, after the last field is tabbed a new blank form appears. Is there a way to simply recycle through the tab order? In other words, after the last field is tabbed, it returns to the first tab field. 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...

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

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

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

Hello, Is there a VBA command/code to close a command window? I have a line that maps a network drive then performs some functions and disconnects the mapped drive (I tried coding via UNC path but that bombs). Shell "net use V: \\ce_laptop2\sidewalks /y" A temporary command window opens and...

Hello, I’m having a problem open a second form based on data in the first form. I want to open frmGrades when frmPermits closes to the record containing the same Permit_No. To open frmGrades accordingly I coded: DoCmd.OpenForm "frmGrades", , , "[Permit_No] =" & Forms!frmPermits!Permit_No I...

Hello, I’m having a problem when attempting to run code upon closing a form. I have an IF statement on the OnClose property of a form. However, it’s always running the quesry against record #1. I want it to use data from the current record. CODE: If Me.Request_No > 0 And Me.Grades = -1 Then...

Hello, I have a question on the form property OnGotFocus. I have a Form-A with at command button that opens Form-B (the Form-A remains open). When data entry is complete on Form-B and it is closed, I want Form-A to update based on what was input on Form-B. I have it working if I code...

Hello, Is there a way to remove the focus from a command button after the button has been clicked? I have a Form-A with a Button-B that only becomes visible is certain conditions exist. Button-B opens a second Form-B for additional input (Form-A is still open). Once Form-B is closed, I want...