Search results

Hi - could somebody help me with this please, I'm new to workbench and Ive just uploaded a table into workbench from an excel csv file. In the excel table one of the columns had a date value, I loaded this into my table using workbench as a text file as I was having problems importing this file...

Hi , Could somebody help me with this syntax please for how to combine multiple SQL statements in vba, to change more than one value in a table Ive been experimenting with this from the microsoft site but keep getting syntax errors the code I'm trying is below Dim dbs As Database...

Hi - I have created a query that sums the number of times different selections are made from a dropdown box in a form, this accumulates over the course of a year. I was wondering if its possible to display this value in the form as a live running total. So that when other users make a selection...

Hi, Could somebody help me with this please. I have a form that contains hundreds of records, and the user moves from one record to the next checking/inputting data. I have a Dmax lookup function in the form that calculates a max value for a field when the user makes a selection from a combo...

Hi everyone, I have split up my database the backend is in a shared folder and the front end has been copied onto each users machine (half a dozen users). It may be necessary for the moment to allow all users to access one shared front end, there are not many users, 6 at the most and not...

Hi , I am trying to put a front end database on a laptop with MS Access 365 installed on the machine but when I put the front end on the desktop I get the message below. Ive had googled and tried a couple of things but they havent worked. Has anybody come across this before. Error message...

Hi, Has anybody any advice as to how I might go about this please. I work in an office with no local network, all the machine are laptops (apart from my desktop). Ive created a database in MS Access that sits on my desktop. Ive split the database into front end and back end and would like to...

Hi all, I have a search text box that sits above a nav form, so when I enter a value in the text box and click the button the value is found in the form. But how do I continue to search for the same value starting, again, from where the first occurrence has been found in the form. Ive tried to...

Hi everybody, Has anybody any experience of migrating an MS Access database to the cloud to using Amazon AWS? Ive been asked to do this with the database Ive built. Ive created an RDS instance following their guidance but found the rest of the documentation is way over my head. Has anybody...

Hi, I have this code that works and tells me lets me know if a number exists in a field. So txtFindNumber say 1234.001 exists in the field 'fldNumber' - but I need to bookmark the once its found so the user can edit it - how would I do this please? Ive had a look at the doc.microsoft page and...

Hello everybody, I have a script using Python that uses the INSERT statement to input data into a table, using something like the test statement below cursor.execute(' INSERT INTO tbl_test (fld_PK, fld_value1, fld_value2) VALUES (?,?,?)'),(ID, name, address)) This wont work if I have a...

Hello everybody, Ive been struggling with this for the last day or so. I've tried 2 ways. I am trying to insert text (names/address etc) into the body of an email (with terms and conditions etc) that has been loaded as a template in MS Access. The problem is I need a check box in the email body...

Hi, I am getting really confused with how to use Dlookup with navigation forms, if its possible at all! if I have a navigation form with Form1 and Form2 as tabs on the menu , so I want to find what the HospitalID value is based on the fldPatientID (which is also in Form2) Form1...

Hi, if somebody could give some advice with this please Ive been going around in circles with it If I have a form called Form1 within a Navigation Form called frmNavigation (so the menu tab on the nav form will read Form1) if I have a text box that sits above and outside the navigation menu...

Hi - I'm trying to understand how to pull out values from a within related tables. I have a test example below to try and show this problem. If for example I have 2 tables titled Table1 and Table2. I loop through a particular field in the first table, and with each value, I want to find the...

Hi, I am new to Access/VBA I am having trouble adding values to this list box from within a module. I was thinking I might use the results of the module within other parts of the database. I'm doing something wrong but cant figure out what it is, the module works on its own but the listbox...

Hi everyone, I have been trying to pull out common fields in a textbox above a navigation menu so as I browse and search for something if I click on a different menu (say hospital in the example attached) the patient name would still be visible. Ive been reading past threads and I remember...

Hi everybody, Hope somebody could help me with this please I am trying to redesign my main menu and move a vba search box so it sits outside and above the main navigation menu on the form . The field I am trying to search for, lies in more than one form which the user can select by selecting a...

Hi Everybody, I learning MS Access and ive have been asked me to build a database, there will only be a handful of users and maybe a few thousand record entries. The users of the database will be at different locations and their computers are not networked, so Ive been thinking of putting the...

Hi there, I have 2 tables in Access, the primary table is called tbl_Clients, with a form frm_Clients, which is used by the user to create a new client record, tbl_Clients has a primary key ClientID. The second table is called tbl_Reports with a form, frm_Reports, this table uses ClientID as...