Search results

INSERT INTO [Detail] ( ADID_CD, [TOT POP], LOAD_PRD, RUN_DATE, Run, ReportYYYYMM ) SELECT Billed.ADID_CD, Billed.EMPL_ASGND_BF_MACH_CNT AS [TOT POP], Billed.LOAD_PRD, Billed.RUN_DATE, [Run Table].Report_Run, [Run Table].ReportYYYYMM FROM ([ADID Rollup] INNER JOIN Billed ON [ADID Rollup].REPADID...

I have a table that has one field and I want to use this field as a query criteria . when i click on CRITERIA & BUILD, Access lets me select the table field and shows [tblBillRun]![Bill_Run] for the criteria but when I click RUN, it prompts me to ENTER PARAMETER VALUE. What am i doing wrong?

How do I convert '130330' to date in Access? I want to convert to 03/30/13, any help will be highly appreciated

The below query gives an error message whenever it encounters anAccount name with apostrophe like "Testing's" ("Select * from Report_History_Table where AccountName Like '" & ([Forms]![Request lookup and update]![ctlName]) & "*' and (Status = 'Open' or Status = 'Monitor') ") Below is the...

thank you all for your help,

I have a table with some Yes (-1)/NO (0) fields, i want if a checkbox on a form is checked to assign a Yes (-1) value to the table, if not checked assign No (0) the below code assigns a Yes value regardless of whether the checkbox is checked or not, what am i missing? please help If...

BE/FE was created with Access 2003, some users are on Access 2010 onWindows 7 while some are on 2003 on XP, not sure about the server

were you able to resolve this problem? looks like I'm having the same problem

the update works well, the code adds records to the table very well. the problem occurs after the records have been added. I can neither delete the record not make changes. once a record is added, the table locks up. i do not want the table to lock, i want to be able to make changes or delete...

No, the PK ws not removed, I added more fields to the table. is there a limit to the no of memo field that can be on a table? below is the code that updates the recordset Private Sub CmdSaveNew_Click() On Error GoTo Tina Tina: If IsNull(ctlName) Then MsgBox "Please enter your name"...

I have refreshed link, I can see the changes to the fields but the records are locked. when I try to edit, it tells me someone else is making change to the same data but I am the only one that have access to this table

I have a linked table (ODBC) that was working perfectly ok but after nes field were added to the table, it locked up. I can add records but not delete nor edit, how can I unlock this table to allow edits?

I have an ODBC linked table, i have access to add, delete, edit etc. Just recently, after changed were made to the table(added more fields), i can add records but cannot edit nor delete. I get this error message whenever i tried to either delete or edit "Error 3197 - the microsoft jetbase...

that worked, thank you very much!

thanks for helping, I am not using a query, i am using the below code Dim db As Database Set db = CurrentDb Dim tblpool As Recordset Dim Sixtyplus As Integer Dim rstemp As Recordset Dim rstemp2 As Recordset Dim rstemp1 As Recordset Dim rstemp3 As Recordset Dim ctl As Control tblpool.AddNew...

I have a textbox on a form for entering date. this field is optional meaning it could be blank. when I leave this field blank & click save to update table (table is not bound to form), I get 3421 data type conversion error. how can i get this field to accept blanks as well as dates? it works...

thanks, that helped but when the form first loads & XNAC2 is left blank during update, the above code works perfectly fine however after saving and form clears, if i try to do just the same thing - leave XNAC2 blank it goes back to the same problem - adds up everything

I have a form with two text boxes(XNAC & XNAC1) and 1 comman button(Save). When the save button is clicked, i want to run a query to bring back the sum of amount where XNAC(from my table) matches either XNAC or XNAC1. the code runs but the total(sum) that it brings back is incorrect. what am i...

I have a checkox called chkdefine & textbox called definedate, I want if chkdefine on the form is checked and Definedate is not null, assign Definedate value to definedate(on the table). However if chkdefine is checked and Definedate is null, I want assign current date to definedate. the below...

I want if chkdefine is checked, I want to check if Definedate is null, if Definedate is not null, I do not want it to change but if it is null, i want it to update to current date. I have the below code but it does not seem to be working, please help If ChkDefine.Value = True And...