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

good its wrking.. :) One last question pls... I've added some colors but its not turning correctly.. any idea how to make the following black background with white font , Dark red background with white font, dark grey background with white font...

When click on the export button.. am getting the screen > output To (Select Output format) in which there is Excel 97 - Excel 2003 workbook. If i select this option getting screen "Microsoft Excel - Compatibility Checker " after clicking on continue it opening the formatted excel. Is there a...

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

do u have a sample for how to do it pls?

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

yes the fields in the forms will be editable except some will be read only. but it the datasheet is it possible to make status and date registered as editable as it will be easy to copy paste the same data for other records.

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

u mean to add 'Form.Form.Requery" in the form properties?

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

is there a way to do it via vba codes? instead of changing the access settings. the text box value going to be like "AB |1234" cursor should be at the pipe when to input the values.

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

Thanks the last modified user & date is working. :) along with the last modified, how can i add another field "No.Of form data changed" that get incremented each time that a change is done to that form?

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.

yeah thts right.. it ok. thanks a lot Jack for ur help :)

pls find attached the Db. Seems the error is linked with the label text below comments.

hi, ive added a drop-down field "Status" in the form and getting below error wen it adding / saving record. Please advise. ActiveForm is customer Label43 Error 438 in form_customer being ignored -6/2/2019 2:44:31 PM Error 2427 in line 450 (You entered an expression that has no value.)...