I have a database for patient details with one table . It has a unique ID field, and an NHSNo field (which is a text field - it needs spaces), which is also...

Hi, Please forgive the reposting, but my original post didn't receive an answer and I'm really hoping someone can help. I have an unbound form...

Hi Am using Mark Plumptons method to speed up form loading. This is the first time I have done this so being extra careful. Problem is I have a combo box...

Hi, I have a database with a query with patient referral details plus some calculated fields. We need to monitor whether the patients are referred on fast...

Hello, I have a form that when opens up, it opens up in ADD Record Mode. How can set it so when it opens up it looks for the last workorder_id PK entered...

I have the table with all the employee data, including one text type, called "photo". In that cell I have the path to the photo I wish to display. I also...

In a multiuser setting on split db, one user has "lost" the db toolbar. Yesterday, the toolbar was available and this morning when logging in to db and...

I've got a form for entering information into my database. The first piece of information entered is the date time group (in the format yymmdd e.g 071101 is...

I've been racking by brain and various books to find some answers, but to no avail. I need assistance with a simple task. I have a combo box that looks up...

Access 2003 I have a form and there is a combo box named cboRecordSeriesItemNumber it is based on a query "qRecordSeriesSource" from two tables. There are...

I want to print the current record in the form, I am using the following code: Private Sub cmdPrint_Click() Dim strWhere As String If Me.Dirty Then ...

I am creating a form with many fields. I have reached 22" wide on the form which seems to be the maximum width. Is this correct, or is there a way to...

In a text field I can potentially have at least one space in a string. What code can I use to detect this space, bring up an error message and then delete...

I have a form that has a listbox wich displays a filtered table. I would like to print a report of the contents of that listbox. This seems like an easy...

on my sub form (subDetails) I have a totals column. I then Total the totals column in the footer of the subform in a field named (txtOrderTotal) I want to...

I have a set of fields on a form that are bound(using Control Source property) to a table. Everytime I close the form by clicking X, it always add new row to...

In a subform, in datasheet view, is there a way to make the first line the new record instead of the bottom line? -- John 3:16 "For God so loved the world...

I am using ms Acess 2k3 and have downloaded a database. When I open some of the forms, I am having problems. The warning is that some expressions may not be...

I have a button in a database form to email the text in .rtf format but it always gives the database engine error only on the one computer. I am totally...

Hi: I have a list box named org, and I trying to make it work; the multiselect property is set Extended. Where the below code should be placed; also what is...