Search results

hi, pls help.. how to disable the form/ design/ datasheet view in access via VBA when right-click on a tab.. ? Ive tried to below options but its does fit for some scenario: > un-check the "Allow default menus" in options. But its disabling the hide/ freeze etc options for the table. > I...

Hi, i have below code attached to a button in access form. How can i amend same such that when it export into the excel: the header first row(A1 to J1) is bold and calibri font 14; row A2 to A5 - bold and A1 TO J5 get border line. Dim outputStats As String outputStats = CurrentProject.Path &...

Hi, how to export data generated from a query into an excel when a button is clicked.?

Hi, I want to automatically load multiple excel files save in one folder to respective access tables: customers.xlsx (id, name, address, street, phone, email) sales.xlsx (sales id, description) product.xlsx (product_id, product_name, comments) orders.xlsx (order_id, order_date, order_by) Excel...

hi, I have a split form with a datasheet on bottom. Form and datasheet contains these fields: Name | Address | Phone | Email address | Date_Registered | Status How can i set specific fields (date_registered & status) as read-only in the datasheet? in the properties, only Allow Edits & Read...

Hi, I've created a form split form using the wizard link to a table that already contains data. The forms contains text box and 2 buttons "Name Search", "Add record". When adding details in the form textbox and click on add button the data getting saved in the table. But i am not getting the...

Hi, I have a text box "txt_name" in access16, with input mask as "AB "0000a;0 How can i set the cursor to start after AB <Space> for the textbox "txt_name".

hi, In my form i have a field drop-down status with values (WIP, On-Hold, Completed) i want that once the status for a task is set to Completed. Alll the details for that task is moved to another table. how can i do that?

hi, in a form, i have 2 fields: country which is text field category which is a drop-down containing values Europe, US, Asia, Africa, None how can i add a validation e.g when input country = "France" then in the drop-down values for category NONE should be disabled Pls advise?

hi in access2016 form, i have 5fields (name, address, phone, email and comments) that read from table tbl_customer how can i add the last_updated_by (user that has login) and last_updated_date (date/time)fields.

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...

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.

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

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?

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?

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...

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.

hi, i have a form with a dropdown list of values e.g category (values, A , B, C). When select on category, it should display a kind of checklist which will need to tick and save value in table. each category A, B , C will have their own checklist. sample db attached. whats the best way.. to...

hi access 16, have several text box (ID, CIR, Name) in a form with a save btn.. if when input a CIR that already exist then below display added the code in before_update.. how to amend it that when click on yes it goes to next text box i.e name when click on no.. it clear the text box CIR...