Search results

Good morning :) I have a button on the main screen that the user presses to backup the database and exit the system. I realise it's not the ideal backup solution, but it's what was requested and works for them. The button creates a sub-directory in existing directory "Database Backups" with...

Good afternoon, I created a system in Access 2016 which my client has been successfully running for some time now. Her machine has Access 365, but when I install on her machine I remove all Access functionality and it has been 100%. As of today, no box borders are showing on any reports or...

I have hit a bit of a snag with moving between fields on a form. If I use the <TAB> key the contents of the field is highlighted (as I expect it to be - I selected "Behavior on entering field / Select entire field" in Options / Client Settings. However, if I click on a field, the cursor is...

Good morning :) I am creating a report which lists outstanding jobs and their cost. The Cost value is dependent on a "CostPer" field which has a value of "Job", "Each" or "1000". So the calc will be If CostPer = Job Then TotalCost = Cost1 + Cost2 ElseIf CostPer = Each Then TotalCost =...

I split my database (Name1), and everything was working fine. I then saved Name1_be.accdb to Name2_be.accdb and Name1.accdb to Name2.accdb. Now my queries are not picking up any data in Name2.accdb. I have relinked the tables in Name2.accdb, but it's like the accdb is not seeing the tables in...

Hi all :) I have a table "Branches" that has the fields "CustCode" ,"BranchNo" and "BranchName". I have another table "Jobs" where each record has a field "CustCode" and "Branch No". I am using DLookup to look up various fields in various tables in order to construct a new record in the...

I have frmJobs with subform frmJobParts - data comes from table Jobs and JobParts. I am trying to copy multiple records in table JobParts for a previous job (the value comes from [frmJobs]![txtPrevJobNo]) and append them to the JobParts table, but with an updated job number (value comes...

Good morning! I have a Jobs form which calls a Job Search form with a button. The job form is populated from the jobs table, with Customer name from the Customer table and Factory name from the Factory table. The Recordsource for the Jobs form is set from a query I built: SELECT Jobs.*...

I have a form - frmCustomer. If the user clicks on the "Search" button a new form - frmCustSearch opens, without frmCustomer being closed. In the declaration section of frmCustomer, I declare a variable to store the customer code selected in frmCustSearch: Public PassCustCode As Integer When...

I have a search form which contains 2 listboxes. The first one lists all the customers and when the user picks a customer (On Click event) the second listbox displays all the jobs for that customer. lstCustName is populated from the Customer table with CustNo and CustName, bound on CustCode...

I have a "Job" form, which contains a JobType field. It also contains an Option Group for costing, with 3 radio buttons. Which type of job is selected (1, 2, or 3) will dictate which of the radio buttons are enabled. On opening the form, as well as when the user changes any of the values that...

Estelle here. I wrote a workflow system for a client in VB6 in 1999, and they have asked me to rewrite it so it can run on a Windows 10 laptop. After dabbling in C# and VB, I decided Access 2016 was probably the best way to go about this - it will be a single user application for a relatively...