Search results

This is a set of queries to perform calculations. I realize I probably did it the long way around but other than showing all records all calucations are coming out right and the set does exactly what I want it to do. I'm thinking that I'm just not quering the table of listings but i'm not sure...

I'm sort of new to access but I have been developing an inventory/sales/order tracking etc database and I use forms to enter information into my tables. My understanding of access is as follows this may not be completely correct but... Tables - Store data Queries - manipulate data from tables...

Hi! I have run into a snag that I have not been able to figure out. I have a database for my ebay auctions I have a table for the listings which includes date and fee etc. I want a query that pulls from the table of listings but also from my sales tables so I can create a PivotChart that shows...

Has anyone else had this problem? I still have not figured it out....

Thanks for the information! I had no idea there was a limit well that isn't totaly true i had read something about it but I had no idea how many.

everytime i try to save a record from my form i get a message saying "the command or action 'SaveRecord' isn't available now." but the weird thing is the record IS being saved! any idea's why this is happening and how to fix it? Thanks Nicolette

ok i was wondering how to make a command button that would save my customer info in the first form and would then open the form to create an order with that specific customers ID and name and such already filled out in the second form....

yeah i have got and i have looked at it but it is too much to follow and i keep getting lost I need a road map LOL!

it does thanks!

oh sure I can change that! sorry about that

Nevermind I got it

hi I have a report that shows how many house a person works I got the clockin and out done but i can't get this code to show the total amount of time worked it says it is a circular reference =[TotalHours] \ 60 & Format([TotalHours] Mod 60, "\:00") I'm working off this tutorial...

ok I'm playing with this and it isn't working I'm not that far into learning VB yet so if you could offer some help it is greatly appreciated. Private Sub Form_Error(DataErr As Integer, Response As Integer) Const conErrDuplicateKey = 3022 Select Case DataErr Case conErrDuplicateKey...

ok I made it so I can't accidently add the same customer a second time but I was wondering if there was a way to create my own error message instead of the one Access pops up? I believe it is error code 3022 it reads: The changes you requested to the table were not successful because they...

true! don't really know why i was worried about it LOL!

Can I set the default value of a textbox on a subform to the calculated total on another subform? I calculate the total of an order in one subform another subform allows me to record a payment can i have the default value of the PaymentAmount Textbox be the total calculated? I tried...

Thanks I read about resetting the autonumber somewhere but I couldn't find it again! thanks so much!

Is there a way to reset an autonumber field after testing the db without having to delete the relationships? Also can you tell the autonumber field where to start say 100 instead of 1?

I am currently reading about user-defined type and I read "Define and use a structure data type when you need to combine various data types into a single unit, or when none of the elementary data types serve your needs." Is this needed for all UDT's? or just "when you need to combine various...

Ok well i think I have a pretty good basic understanding of Access... and if it isn't gonna help in learning vba then i'll just upgrade at a later date