Search results for query: *

Hello, I am working on a DBS here... if I do the: On/Off, CONF, #, 5, (Port Number)... I get the Port and Extension Info... (Port 25, Extension 124) I set up my wiring properly... I made sure the phone works... But when i plug it into the wall, it aint workin... (Port 25), (ext 124).. When...

Private Sub TextJobID_LostFocus() Dim stRunCheck As String stRunCheck = "qryJobID_Check" DoCmd.OpenQuery stRunCheck, acViewNormal, acEdit Dim inJobID As Integer Dim inCheckResult As Integer inJobID = Forms!frmOP2.TextJobID...

Here is a copy of the code in my form: Private Sub OpenFormOP2() On Error GoTo Err_OP1Start_Click Dim stOP2Start As String DoCmd.OpenQuery stOP2Start, acViewNormal, acEdit Exit_OpenFormOP2: Exit Sub Err_OP2Start_Click: MsgBox Err.Description Resume Exit_OpenFormOP2...

Here is my code (Im getting the error: Run-time error '3061': Too few parameters. Expected 1. " Private Sub txtGagePoint_Click() On Error GoTo GagePoint_Enter Dim db As Database Dim qry As QueryDef Dim rst As Recordset Dim stDocName As String DoCmd.SetWarnings False stDocName =...

Ok.. I have a form "Job Order Entry", it is linked to a table "Job Order Entry" Inside of the formJob Order Entry, is a Drop down Box "CamProfiles"... I have a new text box in the form called "Gage Point". Now, the Drop Down box call CamProfiles is...

Thanks ahead of time.... I have a report that gets its info from a table... the table comes from a make-table query... Inside of the Make-Table query are 4 tables.. Ok.. The problem.... I have 2 variables comming from the table.... I want a text box to show the sum of 2 other values from the...

Hello all, I have a table (Job Order) with a lot of data... Ok, I want to take a row from this table, which I am querying by (Job Number), say 15655. Now I would like to append the original table (Job Order) with the same data EXCEPT change the (Job Number) from 15655 to say 21010. Note...

I have two servers running SQL 7.0. One replicates to the other... under views I have syncobj_0x123456.... What is this? Also, I am running an access 97 DB, when I want o link tables I get these along with the list of tables??? Why?

I have an Access DB run off of the Server. All users run the shortcut to access the DB. One of my queries run slow. Is it possible to run a query localy? When I copy the DB to my system it runs fast.. Any suggestions??

Hello, I have a form, and a make-Table Query, the query uses two combo boxes from the form to get the query info. Question: I need the query to automatically run when the second combo box is chosen, also, how can my text boxes is the same form use this data from the make-table query as its...

I have a query that takes criteia from one combo box and two text boxes from a form. It is layed out like this: The first criteria takes from a combo box, Forging, and searches a table like this. ForgingID field: [Forms]![frm_openForgingForSales].[Combo1]. ForgingID1 field OR...

Hello all, I am having difficulty getting data to beome a default value in a form. My Access database is as follows. I have one form, in which the control sorce is a table to store information in all the fields. I have three combo boxes that a query uses to get default data for the above...

I have an Access front end with linked SQL tables. when I try to run the action, I get this error: Field 'tbl_XXX_.PO# ' can't be a zero-length string? What should I do? On the table itself where it gets the data from is blank, no value?