Search results

I'm trying to create a trigger that be able to update the UnitsOnHand (field) in the tblproduct table when an order is inserted, modified, or deleted in the tblOrder table. If an order is added it should take away from unitsonhand. If an order is modified it should add or take away depending on...

I'm trying to add some life to my form by using some different colors, but I can't figure out how to change the color of a button. Does anyone know how to do this? Thanks

Hi, I'm having a hard time setting the recordsource in a subform dynamically. here's what I have Main Form code: Public Sub Form_Current() Me.s_frmPurchaseOrder.Form.RecordSource = "EXEC spProductList " & Me!lstOrder Debug.Print s_frmPurchaseOrder.Form.RecordSource End Sub The debug...

Anyway to pass array this? Hi, I was wondering what is the best way to pass the contents of an array from one procedure to another. Any help is appreciated, thanks. ** I think the title of the post was misleading, so I changed it.

Hi, I am trying to execute a stored procedure that take in 1 (datetime) parameter. Everytime I try and execute it I get the following error, which makes no sense to me. "Procedure 'Shipping' expects parameter '@ShipDate, which was not supplied. Any help is appreciated, thanks. Here is the...

** Solved Hi, I was just wondering what goes into a data dictionary. Which of the following should be included in a data dictonary - tables - constraints - triggers - stored procedures - queries I'm sure the first two apply, but I'm not sure about the last three. Any help is appreciated, thanks.

I'm using access 2003, and for some stupid reason they decided to remove the "clear" method from listboxes... In previous access version I could clear a listbox using "listbox.clear", but now I have no idea. Does anyone know a good way to clear listboxes in Access 2003.

Hi, I am having some weird problems when using bookmarks. All I want to do is display 1 record at a time in a listbox each time a user clicks a button. At the moment I save the bookmark value to a global variable, and when the user makes another click is should move to that record. Right now...

Hi, I am trying to figure out a way to keep record of store hours, and days open for lots of different restaurants. The only thing I could up with is the following. I'm not sure how to keep track of store hours, or even the best way to make a table for hours. Any help is appreciated, thanks...

In theory the tables below, and their relationshio make sense to me. I know I could have done two tables, and skipped the third table, but for this project it has to be like that. Right now I am using an autonumber dataype for tblPersons (PerID), and using an int for the other two primary keys...

I'm not sure what this kinda of table setup is called, or if even has a name. I Have four tables: tblEmployees tblSalesPerson tblRepairman tblCustomers Each of these tables has common fields such as: Name (first/Last) Address Phone# etc... Should I make a table separate table that contains...

I'm completely lost on this one. I'm working on an "add record" button, but I have to populate fields from two different tables with it. All the fields except the "Genre" Field are from the same table This is what I have so far, as you can see I'm currently only opening a recordset from one...

Hi, sorry to make a new topic so soon, but I ran into some SQL problems with my form. Right now I just have a combo box that contains different genres that should only load up albums associated with the selected genre in a listbox. I first tried creating the query in the query design view, and...

Hi, I'm working on a small personal database to try and get some of concepts down. I'm having some difficulty understanding data entry for the M to M relationship between the tblAlbums and tblTracks (data entry without using forms). I can fill in the tblAlbum, and tblTrack tables separately...

I'm just curious as to what methods people use to get the ball rolling on their databases. I'm not sure if I'm using the most effective way to setting up tables. I clump all the fields in one long list, and try to break them down into tables and normalize them. This doesn't seem like a very...

Hi, I'm in the process of making a super simple database (3 - tables). I have run into a problem with two of the tables. The relationship between them is one -> many. Say, I have a record in the (one) table which contains a primary key that is also part of a compound primary key in the (many)...

Hi, I haven't touched access in a awhile, and forgot quite a bit :( I was wondering what is he most simple, and effective way of using one combo or listbox value to populate another combo or listbox? I'm not even sure if I have to create a connection, and recordset. I recall there was a few...

Hi, I'm trying to figure out what exactly is the difference between the following: Row Source Type: - Table/Query - Field List - Value List I know it may sound like a stupid question, but I could not find any useful information on this anywhere. I'm trying to make a simple database, and I...