Search results

I'm using Allen Browne's Concatenate Function to concatenate the many phone number records of one person into one field of a record. i.e. John Smith | 02038483956 John Smith | 07593999493 Jim Jones | 07540029938 James Williams | 02079348395 James Williams |...

I've been trying to do this for hours; can't find a solution. I've got a continuous form, with a button (cmd1) on each record. Each record has a unique primary key, RecordID. cmd1 is clicked to open a form (frm1) based on the RecordID using the following code: DoCmd.OpenForm "frm1", , ...

Nothing else to explain really. How can I get my database to make a beep sound when something is trying to be typed into a locked textbox control? This is so that my users can know that it's locked (much like when the delete button is pressed on a new record). Thanks.

I am using the below code to centre a popup form, both horizontally and vertically. All my non-popup forms are 25cm wide. It looks weird that the popup forms appear on the centre of the screen, when the centre of the form is more towards the left. This is especially true in widescreens. How...

I get the above error when using code to centre a popup form. I am using 64-bit Windows with 64-bit MS Office, but I want this code to work on both 32-bit and 64-bit (Windows / MS Office) and if it matters at all, on all versions of Windows above XP. How do I get it to do just that? Sorry for...

Hi guys, Is there an efficient way anyone knows of, to have default text in a textbox on my form (like a search box), but have it so that when a user focuses on the textbox (to type in a search term), the word should disappear. Just like the search box on windows 7 start menu. Then, is there...

I've got a continuous form based on a query. Each of the fields have a search box below it (in the footer) which should ideally filter the query. I'm starting with the FirstName field. In the form's query, I've set the criteria to the following for the FirstName field: Like "*" &...

Here's the scenario: There's a button(Button1) on the main form (Form1) and on the second form (Form2). On Form1, I've got a link(LinkToForm2) to Form2. When people click on LinkToForm2, I want access to open Form2 and hide/show Button1 depending on whether it is shown/hidden in Form1...

Does anyone have any experience or knowledge of sharing a backend of a split access database using these services. I want to access my database from different locations. More than 1 user may be using it at the same time. Can I put the back-end of a split database in a Google Drive folder or a...

Is it supposed to do this? Am I doing something wrong? Picture attached. Thanks.

If I set a variable inside of a subroutine, it is set to nothing upon the end of the sub. Can I set a variable outside a sub and set its value, so that you can use it within subs? I'm new to coding.

I thought I'd find this to be a fairly common demand and that I'd find the answer by googling, but to no avail. I've got buttons (on the header of my form) that I plan to make act as tabs for a single record. Each button should display more information for the same person (basically, more...

My form is made up of multiple tables that have a 1-to-1 relationship. It also has a subform which is a 1-to-many relationship. Adding a record from the form by filling in fields only from the main table works fine, but, if I fill in a field from another table, it sometimes works and sometimes...

Is there a way to make a popup list open on click of a button (cmdAssign) and the user chooses/selects something from the list, then the popup closes and the textbox (txtAssignmentNo) is filled with the choice?

In my form's table (tblMain), I've got a lookup field (drop-down list) that lists the primary key field from a different table (tblDiff). tblDiff includes 3 more fields. In my form for tblMain, I want to include 3 more textboxes that get filled up with these 3 fields from tblDiff when the...

I've got a table, where each record is a group of students. So the fields include Student1, Student2, Student3, etc. I know this is bad database design, but I've done this because I want the group number (primary key) to be automatically generated. Now, I want to add more information for each...

I've got an address box on my form. When someone enters 'London' inside the box, I want only 'london' to be changed to all-caps.

When I add new records to the form and close the form, the tables are updated with the new records, but the new records don't show in the form (navigation).

How would I say this: If ctl.Visible = False Then Set ctl to "ilovepizza" So later, I can call it saying: ilovepizza.Visible = False

How do I get VBA to say: Go to the first control in the tab index after the current active control (that is visible atm), except such and such controls (because they will lose visibility in a moment).