Search results

i am using it on a report. if the status is one of those numbers then i need comment 1. if the mny_amount <> monthly_amt*payment_schedule then comment 2. else comment 3. i don't think i can use select case for this scenario either.

this is probably simple, but ... i can do this in crystal reports, however, it does not seem to work in access: if {tbl_transactions.tnyint_transaction_status} in [8,4,10,15,20,25,30,35] then ..... meaning if status is one of those numbers, then ... how do i do that in access? is...

thanks. for future readers: works with just one tiny correction. it should read: docmd.transferdatabas ac import, "Dbase 5.0", "f:\path", actable, "current.dbf", "after" (just the path - not the file)

i tried this DoCmd.TransferSpreadsheet acImport, 8, "after", "f:\path\current.dbf", False, "" i get error message "external table is not in the expected format" when i tried this DoCmd.TransferText acImportDelim, "", "after", "f:\path\current.dbf", False, "" i get error message "cannot...

just tried it. works great. thanks

i'm talking of the close button that closes the entire program

when a user clicks the close button from the main form, i want to save the time and do a few other things. where do i put the code for that? or is it better to disable that button and force users to use a button that i create (that will have the coding i need behind it)?

i want to import a .dbf file. i am able to do it from file>get external data>import. and it imports nicely however, when i try to write code for it with transfertext, i get an error message "Cannot update. Database or object is read-only." the file is not a read only and i can import it the...

new files. every day, i import info, work with it and then export the new files. i could have up to 5 files a day.

because they already exist

thanks. but i don't think that really solves my problem. i don't do it all at one time. i guess what i am looking for is the most recent file name. then i'd read the name to find the number and then determine the new name. i can read the name to find the number and i can determine the new...

i have that part down. i can find if the filename exists. i need to know how to name the file

i have to export a few files a day. i would like to name them filename_date_1 filename_date_2 filename_date_3 ... i want to check if the file name exists and if it does then change the number.

i still have the 'invalid argument' problem with the openrecordset line. if i take out the line entirely, i get 'object required'. if i take out the dbSeeChanges, i get ' ...need dbSeeChanges ... IDENTITY column'. what do i do?

yes, it is. i changed that. still getting the error 'invalid argument'. it comes at the openrecordset line. if i take out the dbopendynaset, etc., i will get error message about needing dbSeeChanges. the table is on the server, linked by using ODBC. the table also has an autonumber.

made some changes, now it reads: Set db = CurrentDb Set rs = Recordset Set rs = db.OpenRecordset("dbo_tbl_transactions", dbopendynaset, dbSeeChanges, dbOptimistic) strSQL = "UPDATE rs " & _ "SET [sdt_transaction_date] = #" & updated_trans_date & "# " & _...

thanks for the quick response. i changed the quotes. it reads as follows: Set dbs = CurrentDb() Set mytable = db.openrecordset("dbo_tbl_transactions", dbOpenDynaset, dbSeeChanges) strSQL = "UPDATE mytable " & _ "SET [sdt_transaction_date] = #" & updated_trans_date...

i am trying to update a field in my SQL table. this is what i have so far, but it doesn't work properly. strSQL = "UPDATE [dbo_tbl_transactions] SET [sdt_transaction_date] = #" & updated_trans_date & "#"" &_ "WHERE [int_member_id] = '" & int_id" dbs.execute strSQL updated_trans_date is a...

that won't work well. i have a list of notes for each member. each note is a separate record. i want the user to see all the notes as one record.

is there anything that can be done? i need to size the field by the length of the field.