Search results

Hi all, I hope somebody can point out my vba errors. What I am trying to achieve is to have a full-screen splash screen open when the databse is opened. This is to be displayed for 10 seconds. In the meantime, 3 other forms are to be loaded in the background. When the 10 seconds is up, the...

Thankyou, I'll go for the double entry then, but how would I go about this in practice? I'd need a form that would enter two rows of data. How do you do this?

I am setting up a simple personal finance database and wondered if anybody could clear up which is the best way to do the following. I have a transaction table with the following fields: TxnID (PK) TxnType (FK) TxnPayee (FK) TxnPayeeRef (txt) TxnAccountID (FK) TxnDate...

Perfect! Thanks.

OK, I have it working after reading your advice, so thanks for that guys. I've taken it on board about the acSaveYes. Just a couple questions though. If I wanted to close and save, I just need to do the DoCmd.Close command and if I want to close and NOT save I need to precede it with a...

It compiles fine and option explicit does not appear. The example code you supply looks much cleaner. I will try that, but I'm stil confused as at least the message box should work in my code. Incidentally it actually does work if I only include the message box in that sub and nothing else?

I'm not sure what a breakpoint is but even if the afforementioned test isn't being met, then it should still display my message "Close_Save Macro" first as this is before the if statement?

Hi everyone, can anybody help me with my very frustrating problem? I have a form which contains a button named "cmd_OK", in vba I have an event "cmd_OK_Click" which contains the following code: Private Sub cmd_OK_Click() MsgBox "OK Button Pressed" ' TROUBLESHOOTING MESSAGE Close_Save End...

That's how switchboards work. It is only one form and access fills in the items in depending on which switchboard you want to display. The code I have given you should change the title of the switchboard on each different instance, but if you want to be able to change the actual design then...

Try this, in visual basic for the switchboard form, edit the code to add two new lines, as shown in red here: Private Sub Form_Current() ' Update the caption and fill in the list of options. Me.Caption = Nz(Me![ItemText], "") Label1.Caption = Me.Caption Label2.Caption = Me.Caption...

Hi, thanks for the reply but that is not exactly what I am looking for. The result of what you are suggest would put the people's names as column headings which is not what I want. What I require is the column headings to be 'Trainer 1', 'Trainer 2', etc, with the person's name as the actual...

Hi, I am hoping somebody can help with a small problem I am having trying to create a query for use in a report. I am sure it must be a crosstab query that I need to create but I'm not sure how it will work. Currently I have three tables that will be involved, and these are as follows. I have...

Actually, to clear it up a little. I think what I'm looking for is to return the results of two separate queries (both with identical fields) - as one list.

I wasn't sure what to title this thread, as I'm really not sure how this will work so I hope somebody can help. Ok, what I have is a training database, with an employees table, and a training items table. trainingitems table: - trainingitem_id (PK) - trainingitem_description (plus more not...

...is it possible? At them moment my combo boxes look odd compared to the text boxes.

It is set to no. I've just changed it and it now works!!! At last, thanks all for your help, and thanks missinglinq for the solution. I can just set each of the boxes to 'enabled=no' to avoid anybody editing data in the main form.

Anybody? It's so frustrating!

No, it can't be. Fields in my tables are: trainingitems Table: trainingitem_id (Primary Key) trainingitem_description (plus more, not relevent here) trainingdetails table: emp_id trainingitem_id trained_date (plus more, not relevent here) employees table: emp_id (Primary Key) emp_name...

Yes, both true. It is actually set as datasheet view, although it could easily be set as continuous? Would this affect it? The two tables are joined by field trainingitem_id (FK in "trainingdetails", and PK in "trainingitems"). PK in trainingitems is indexed, but duplicates NOT allowed...

Can anybody else help?