Search results

OK, this is what I've got It would work fine if the file was comma delimited, but it's tab. It's not recognising tab as a delimiter, so it's concatenates all the column names and looks for a column in the db called "fistnameSecondnameAddress1....." Can you specify the type of delimiter...

Create a query that groups all the fileds except the ID and the Date and any others that may be different. Make a new table from this query. Add all the columns that were not included, onto the new table. Match the new table with the old table on all columns that have been populated in the...

Try doing something like this Sub If txtDate IS NULL Then MsgBox "Invalid Date entered!" 'Msg2 Else If IsDate(txtDate) Then MsgBox "Valid Date entered" 'Msg1 Else MsgBox "Invalid Date entered!" 'Msg2 End If End If End Sub

OK how are you linking the databases, do you have a linked table setup in your front end.......?

your making this hard for me. The more information you can give me the better. so you back end is A2K, whats you front end.

Which is what? Access/SQL Server/Oracle/Sybase.....

don't know what this means, is it significant. I've never passed sql to an access backend before but I have done it to SQL Server. I've got nothing to do at work today so I'll see if I can work it out and post back in a bit.

Looks like you might be out of luck chewy

OK, whats your setup. waht are you using for a front and back end?

hmmmmmm, I'm using xp. Can anyone using 97 can confirm this?

did you go into the VBA edit screen first...? it was the one just under REM, onlt two options came up on mine. anyway, if you right click the toolbar (vba) then click customise and add the buttons. Comment Block and Uncomment Block (under edit).

I think SQL has a COPY TABLE function. If it doesn't work in Access then again you could create the same effect by going all around the houses........hang on, is it copying into your frontend.......? if thats the case then you need to send the sql command to the backend before it's executed...

OK, a bit out of my league (in the way that I've never done this beofre) but what I think you need to do is to create a function that creates the combo box, or a least it's values, but dependant on a variable passed to it from the form. Obviously depending on the variable, the function would...

theres a toobar button type comment in the help file and it gives you instructions

To what and how are you connecting using odbc?

FoFa, do you mean a different driver than the ODBC that comes with Access? Daniel, most people are pretty active on this site and will find your posts ;)

[Text field] & Mid([Date field], Len([Date field])-8, 2) & Mid([Date field], Len([Date field])-5, 2) & Right([Date field],2) Try that

If the table isn't in use when you update then you should be able to rename the table using SQL, although access can sometines be a bit funny using SQL like this, so it may not work. Somthing like this but you'll need to check the syntax. RENAME TableName TO NewTableName If that doesn't work...

Any access projects guru jump in here, but with access records don't get updated until focus is moved away from the record. Is this right? In any case, I think what you'd have to do is to set button click or event to run a custom built Stored Procedure, probably from VBA, that could then...

I don't really use projects, but I do use SQL Server. You can use the @@Identity function when you create a new record to pass the created ID number back.