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...

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...

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...

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...

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.

Hi, I hope somebody can help dispell my frustration! I am designing an employee's training database. I have a form called "UpdateTrainingRecords" which controls the employees table. In it I have a subform which is in datasheet view. This contains fields emp_id, trainingitem_id...

I found this in the tips section: Only I can't get it to work, I am typing and the error message I get is I'm using Access 2003, can anyone explain what I am doing wrong?

Hi, please can somebody help if possible... I am trying to link two tables. First table, "Employees" has two fields (for simplicity): employee_id and employee_name Second table "Training Details" has three fields (for simplicity): employee_id, training_id, training_date. The training...

I work for a cheese packing company, and I'm starting to think of ways to control our stock in Access. I'm just struggling to picture where I am going to get started. I can picture in my head a design that includes the following tables: products transactions purchase orders production...