Search results

Not sure if this is possible.... My Access front db users have restricted rights and while executing a VBA module (which requires deleting a table in the back db) , an error is thrown up saying it requires administrator privileges to run. The module works fine when I log on through the Admin...

Hi, I'm trying to run a make-table query using VBA such that each time the code is executed, two tables are formed, one with a fixed table name "tbl_CABLE" and the other table having the system date suffixed to its name i.e. tbl_CABLE_13/01/2009 for instance. I've designed a make-table query...

I have a VBA code which picks values from a form, performs calculations on them and then inserts them into a text field in a table. part of the code is: AUTO_NO_ads = Me.list_LOOPS_AVAIL_ads.Column(1, varItm_ads) DWG_ID_ads = Val(1000000 * Me.cbo_SHT_ads) + AUTO_NO_ads + 10000000 The...

I have a text field Dwg_Id in a table which I'm trying to update to a number using: Val(1000000*[tbl_LOOPGEN_shts]![SHT]) + [ tbl_LOOPGEN_shts]![Auto_No]) but it's not letting me do that. Please note SHT is also a text field and Auto_No is AutoNumber. If I only update the field to...

Hi all, I have a Select query as: SELECT (qry_1!SET_NO*qry_2![now]-qry_2![now]+1) AS JBOXT FROM qry_LOOPGEN I want an exception to the usual return as above, If there is a field Tag_Number in qry_LOOPGEN, can I modify the above query to say IF Tag_Number=XYZ, THEN JBOXT=ABC ( that is...

Hi, I know this can be done but I'm a novice at VBA. I have a batch file AutoLoop.bat which I run from command prompt at the moment. The idea is to run a VBA routine behind the onClick event of a command button in Access which would run this batch file in command prompt automatically. Say if...

I have an Access table say Tbl_People that looks like : ID1-ID2-Name-Age-Location xxx-yyy-Mike-25-Essex uuu-vvv-Jack-32-Surrey mmm-nnn-Bob-36-Newcastle I want to transfer this data into another table say Tbl_Output with four columns in the format below: xxx-yyy-Name-Mike xxx-yyy-Age-25...

How can I move multiple columns data into a single column so that: Name Age Location Mike 25 Essex Jack 32 Surrey Bob 36 Newcastle appear in a single column with data appended column-wise as Mike Jack Bob 25 32 36 Essex Surrey Newcastle Any help would...