Search results

Does anyone know how to get a new line in a label using code? I've tried using the Carriage return - Chr(13) and Linefeed Chr(10) characters, but these just generate non-printing type characters. My code looks like this:- strMessage = "Eqpt chosen:" & Chr(10) & Chr(13) & EqptName...

I’m looking for some advice on Referential Integrity... I’m designing a database to loan Equipment. The system will be barcode based, but at it’s most basic a user will scan the equipment they want to borrow, scan the department they are taking it to and then ‘scan’ Confirm. I’ve got no...

This is probably the easiest thing to solve.. I have a form with its recordsource based on a query. However, when the query finds nothing the form opens totally blank. All list boxes, text boxes and most importantly the close button disappear. I'd like it to display an empty list box together...

I'm trying to requery an underlying form using the form name passed by OpenArgs. There's no problem getting the form name, my problem is how can I use this string in the expression to requery the underlying list when I delete records? Example: strCallingForm = [Forms]![MEC Approval].OpenArgs...

I have a form with a sub form based on a many to many junction table, which works fine. If I don't enter any data into the subform no record is created in the junction tables (as you would expect). The main form is base on a table containing Person Info (ID, Name, Address etc..) The junction...

Does anyone know how to display the path of a linked table? I have a split database, and whenever I want to test new things I change the links to local data... I know that it's an accident waiting to happen that I will forget to link back to the live data... What I want to do is display the...

Here's one, I have two related tables in my database. They contain the names of departments, who is in those departments and whether they have the relevant authorisation to approve orders etc.. The database deals with orders, so in several places I need to check if the person logged into the...

One to one relationships.. Using some of the examples on this site, I've created a many to many relationship using a junction table.. It works very well. One of the tables (tbl_PersonInfo) contains person info (PersID (PK), PersName etc) One table contains departments (tbl_Departments) that...