Search results

Hi All, Can someone get me started in the right direction? I have an unbound field on a form "txtScan". This field is populated by a barcode scanner. The data looks like this ~Field1~Field2~Field3~Field4~Field5~Field6~Field7~Field8~Field9 I am using ~ as a delimiter. Since I am encrypting the...

Hi All, Access 2000 I have a form with an "Update" button control. The "Update" executes a query that updates my table from an SQL Server. When it is executed, I need to login to the SQL Server with user name and password before the update could take place. I would like th button to... 1)...

Access 2000 Hi All, I am trying to create a calendar report of activities. I would like to group on the calendar weeks. All weeks need to appear whether there is an activity during that time or not. Field= [ActualDate] My sort/Group is set to [ActualDate] - ascending Group Header -Yes Group...

MS Access 2000 I have 2 tables “MDW” and “LeadList” Each table contains the same type of data (Contact information) Some duplicate records MAY be in both tables.. (I would like to ignore the dupes). Each table has a unique ID field but are in no way related I need to create a 3rd table...

Hi Pat, I 'DO' need the between clause, "BETWEEN 3000 and 3499" also "BETWEEN 3500 and 3999" I am having trouble with it. That is why I have the IF statements. What I need to happen is to count the string US06AB30xx and US06AB35xx as seperate counts... (not sure if this makes sense). My table...

Access 2000 Hi All I am running a dcount I need to count values that are between (and including) 3000 and 3499 the field is cmbLkpSCType I also need to count values that are between (and including) 3500 and 3999 The cmbLkpSCType values are 3000 through 3499 the field is cmbLkpType My...

Access 2000 Hi All. I am running a select query on a date field. I populate the table "date" field from a Microsoft Date and Time Picker Control 6.0(SP6). I havent been able to figure out how to ONLY populate the date portion of the control so my field value containes Date & Time. When I run...

Access 2000 Hi All. I am running a select query on a date field. I populate the table "date" field from a Microsoft Date and Time Picker Control 6.0(SP6). I havent been able to figure out how to ONLY populate the date portion of the control so my field value containes Date & Time. When I run...

Hi KeithG.. No records were being moved because I was missing a LEFT JOIN. This is what worked: DoCmd.RunSQL "INSERT INTO Excel SELECT tImportTemp.* FROM tImportTemp LEFT JOIN Excel ON tImportTemp.OnlineID = Excel.OnlineID WHERE (((tImportTemp.OnlineID) Not In ([Excel]![OnlineID])))" Thank you...

Hi KeithG THANK YOU for your quick response. That seemed to do it...no more errors but, no records are being moved. I will try to work thru that and post again if I can't work it out. Thanks again Detrie

Access 2000. Hi All, I have 2 tables "Excel and "tImportTemp". I know it's not a great idea to name a table "Excel", but, this is what I am stuck with. Each table has the same fields including a field "OnlineID". I want to insert everything from tImportTemp into Excel Where OnlineID fields...

Hello All I have a form with 2 comboboxes cmbFldA cmbValueA cmbFldA uses DAO to list field names of “Table1” I would like to fill cmbValueA with the data contained in the field selected in cmbFldA FROM Table1. It seems everything I’ve tried results in cmbValueA displaying the field name...

Hello all. I am hoping I could get some suggestions on moving forward. My Challenge: Importing data from one table to another where the field names almost never match. My Form has a list box, [lstSelectTable] (this is the FROM table), that lists tables in the currentDb. Also, multiple...