Search results

hi all, i need help on attached audit trail. ive created a form and added an audit trail module and audit table. In the audit table its recording the new and deleted value in field action. Howver, when editing the value, field action is blank. Can u pls check where i went wrong in the code...

Ive tried the mask in the general section but its taking all characters as input. >L\ 0000;0;_ is there another change to do or can we do it via VBA code? On click after update to accept first character A <space><4number>

hi, In a form, i have a text field how can i add a validation for that. Should always start with a Character followed by a space and numbers. e.g A <Space> 0123 A <Space> 9876 the length of the numbers after the space should have length of 4. How to add the leading zeros to it.

its ok when i ve used the query. Ive added more coding in attach DB, getting error in invalid path even if path exists can u pls check wht i did wrong? and how to add a timestamp and move existing file to a backup folder?

Thxs. ive used DoCmd.OutputTo acOutputTable, "client", _ acFormatPDF, "client.pdf", True how can i put specific fields from that table to be export in the pdf and to add a timestamp with that client.pdf ?

hi, in access 2016, In a form, i have a buttons 'Generate pdf' 'Generate excel' How can configure these 2 butons that when click on 'generate pdf' it create specific column in table Customer first_name, last_name, address, phone, mobile into PDF in a specfic folder

thxs I wl try it n let u knw

can u pls assist on how to do that? m new in that .. never created macro in access & scheduling tasks. Do u hv a DB sample plz

heya, pls help.. I have an access application with several tables & forms & reports.. I need to generate daily @05:00am and 22:00pm all data from 1 table customer_tbl in a text file in a specific folder //tsfshare/customer_track/ on a share drive. how to do this scheduling?

whn i run the application there no error. How can i compile it to show specific errors pls?

Hi, in access16, i'm unable to create an accde. In application, have: 7 tables (data for all tables equal approximately to 3500 records) 5queries (simple join queries) 13 forms 3 reports Is there any setting that i need to change prior to create the exe?

yes it seems ok with below code. :) thxs a lot

yeah indeed its confusing wz that embedded macros. Can we implement same via vba? and how to do it??

save btn contains the attached embedded macro.

Actually, if i leave field CustID which is mandatory blanks and goes to next optional text field description and click on Save butn I get msg ' Record has been saved' with Ok btn when click on ok I get error [MacroError].[Description] with ok btn is there a way to change the display msg...

hi, i got a forms with several fields in it. (optional & mandatory) mandatory fields cust.Name CustID Type Debt I have a save button done via on click embedded macro. In the database field, ive set Required to Yes for these fields. How can i amend same that when thse fields are blanks...

Hi, access 2016, I ve hidden all navigation pane & button in menu bar prior to compile the DB into executable. How can i enable only the print button to be displayed so that can print the database filtered data that is available. On form load i have this code.. should anything be added...

want to segregate the year of data.. want to have the main table only for 2019 and that of 2018 record with type not yet CPL. Getting errror : Syntax error in string in query expression '[type] = 'CPL' When using below code: Private Sub Command119_Click() On Error GoTo Err_Command119_Click...

the main table1 contains too much data for several years.. I would like to make a history table that will move all previous year data for 2016, 2017, 2018. Keep only 2019 data in the table1. which query i can add to this on-click btn to do this pls??

hi, Can u pls help.. I have button named 'backup' in a form that when click it copies all data from table1 and move it to table2_bk in the on-click how can i add such that it move all data for 2018 with type = 'CPL' format of date in table1 is DD-MON-YY.