Search results

Hi, I want to know if you can update an Excel file from Access when it is a linked table? I try to do it an update query but get error Cannot update '(expression)'; field not updateable. Is it not possible or do I need to change some settings?

Hi, Hope you can help with this. I have a table that has records with different values for the same person. What I need is to put those values into 1 field. This is an example of the data. Reference name item value 1234 Sam Smith ABT 12 1234 Sam Smith BTE 24 1234 Sam Smith CDE...

I need to create a query which will append the record selected in a form into a table (Print_Table) many times depending on the number in the field Quantity. The form has a dropdown list connected to a table called products. eg. Table products SKU, Description, Barcode 101, product1, 543543543...

Hope someone can correct me here. I have a form with various text, date and combo controls. There is a button at the button that runs a macro (Close NB) at the bottom. What I'm trying to do is bring up a msgbox if certain fields are blank and not run the macro. I only want the macro to run if...

I have form 1 that brings up a record, I then open up form 2 with that record details. On the 2nd form I have a 'status' combo box with values 'OK', 'bad', 'unsubscribe'. I want to change the value of a checkbox, 'Active', on the 1st form, 'Maildelivery', from true to false if the combo value...

I have an on click event to mail a report which works. I want to change the text to include data from a table. I changed the code to include the field 'office' from the table 'Checks' but get an error saying 'Object required'. Code is : Private Sub cmd_mailreport_Click() Dim office As Object...

I have a field which contains various text including an email address which i need to extract. My research says that I need to use a regex code but dont know how to get that into Access. I have attached an example of the file i'm importing into Access. Any help appreciated.

I have a form with a combo list and a check box. The combo list has values 1-4, the default is 1. By default the checked box is ticked I want that if a user changes the combo value from 1 to 2,3 or 4 then the check box changes from true to false.

I have the code below which works if there is data in the field "Email" but crashes if the field is empty. How do i get it to ignore if the field is empty? Dim db As Database Dim rs As Recordset Dim emailadd As String Set db = CurrentDb() Set rs = db.OpenRecordset("sendexpiredproposals")...

I have a button that opens a form which is based on a query. The query has a prompt so when you click the button the prompt pops up. However if nothing is entered you get a VB error 94 error. How do i get it to show a msgbox if the search is empty?

Is it possible to have a form and dependant on the security level of the user, will depend on what control will appear? Or can I have the controls there and lock them to a user? I have a DB of staff directory and I want to lock it so users can only view information, supervisors can edit and...

I have a table with 200 users and need to record their qualifications, some will have more than 1 qualification. Should I make them individual fields eg Field - BA, MSc etc or just have Qualification1, Qualification2, Qualification3, Qualification4 and look up to another table? I will need to...

I want make a date control compulsory if a value is selected from a combo list on the same form. I have Combo List, status, which can be 25%, 50%, 75%, WON or Lost. If the value is WON or LOST I want the date control, Date Project Closed, to be compulsory. I cant set it to insert today's date...

I have a query that takes a value, Proposalvalue, and depending on the currency, loc curr, it calculates the currency. It gets the currency value from the currencies table and appends to TableB eg. proposalvalue currency 50000 1 Currencies id...

I have a blank report and dragged two queries to it so that they are displayed on it. Both queries prompt for a Customer code. How do I get it that I only have to type it in once rather than for each query prompt?

Hi, I've only really done the basics with Access so please help. I have a query showing all active (Yes/No) records and have a form based off a table. There is a blank date field which users can modify. I'd like it that if a user modifies a date, it will change the Yes/No value in a tickbox in...

I need to check if the reference number my query creates, already exists in the table it's being appended to. EG does the query on table A which creates the value '1403ABCDEF01' already exist in table B in the reference field. if it does, change the last 2 digits to 02 and check again until...

Hi all, Just signed up today but been using Access for a while doing what I think is fairly basic stuff. Enjoy using Access as I like being able to create the front end as well as the database and tables.