Search results

Dear members, my recently "robust" application was changed (Forms, Tables, Queries). Ever since I reconnected to the Live Back-end data, I have been experiencing some issues: 1. multiple requests for the password, and then, states not a valid password. On the re-attempt, the password is...

Hi, I appreciate that there are other threads on this, but, they do not specifically cover my issue. I have also read about "Temp Tables", but, I didn't understand how to create a Temp Table, and therefore, I'm not sure how to use these. My Issue: I have a report that references a number...

I have read on many forum pages that Temp Tables cure some errors pertaining to common errors for split DB's (too many records open... or something like that). I have not yet split my DB, but, it would be better if I could. My DB is not large and I do not have many Queries (or Tables). I...

Hi all, I have developed my DB. I want to lock-down the DB to users, and, make the file exclusive to avoid duplication of records and other associated errors. I have gone into the 'Advanced' 'Access Options' and checked the 'Default open mode = Exclusive'. Alas, this does not work. I do...

Hi, I'm terrible now at VB... I think I've lost my marbles getting old! I have tried the following to "activate" a Check Box using a Button... Private Sub Command270_Click() Me.Print_Mark.Value = True End Sub I need help please.

Hello all, I have a subform where I am trying to add select contact details from a table already built and assign those contacts to records in my main form. From when i select the contacts i want some of the other information to populate the other fields. Should I actually try to read the...

Hi, from 1 Form, or, Graphical User Interface (GUI), I would like to dynamically change/load a new Query as the Record Source. I can explain my reasons if required, but, I have tried and failed with some posts already on this forum so I'm tryiong to keep it simple.

Does anyone know hoe to change the Control Source of a Form from a ComboBox within the Form itself? For example, I have several Queries with data in. Each Query has a unique name (obviously). The selection from a ComboBox generates one of the Query names. This is confirmed to me in Design...

I'm trying to create a table/query/form that will auto-generate a unique number for a specific field. i.e. "baked" field with 0001, 0002, 0003... and a "pc" 0001, 0002, 0003... and a "tc" 0001, 0002, 0003... , and so on and so on. o I cannot use the autonumber as this is for a Primary Key to...