Search results

Good morning all, I'm battling with some code that takes a report and sends it out to a client, with a filename built from the [Customer ID] and

Morning all, We are having an intermittent issue with our system We have a main form where the completion details of a record are entered. We log a number of items one of which is a report number. This is a free text field as we denter duplicates on multiple records, but when a new number is...

Morning all, I'm trying to debug this code which worked perfectly with just the [Job Number] field as the folder name, I'm now trying to add in the customer name to the path but when the directory does not exist, the make directory function fails with a path not found error: If I manually...

Good morning all, I have a little bit of VBA that auto creates a folder for a user. I want to extend this to another area of our system and crate a folder based on a field, the only issue I have is in many cases this field will contain one or more "/" and possibly an "&" which I'll need to...

Morning All, We have an intermittent issue, which are always fun. DB is split with the back end residing on a shared network resource. We have our main table, which records are entered and then updated by users at different operations. The main table has an auto number field which is...

Good afternoon, I have a form with a nested sub form to create delivery notes The parent form links to a single table and creates a delivery note number, logs the customer and the date. The sub form is based on a query that contains 2 tables, both tables have the same data in a field in each...

Good morning everyone. We have a large split database, where the backend resides on a nas and 3 - 4 users have the front end on the desktop. The front end is version controlled so everyone is running the same front end. We recently moved the file systems from a NAS to a Debian server with...

Good morning all, Appreciate the help! I have had a quick search but couldn't find this one. I'm sure it'll have been answered before though. Issue: Unbound text box does not display data when form loads and does not update when switching between records on the form. Form Name...