Search results

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

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

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

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

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 so I decided to start over because I really messed up :mad:. Thats ok I'm learning lots! So I have spent much time trying to make sure my tables are normalized as much as I possibly can have them. I did a ton of reading and research and I kept reading that Access Databases work best when...

Is there a way to have a checkbox determine if fields in a form auto populate? I usually keep billing and shipping addresses seperate but I was trying to think of a way to condense it down so I was thinking would it be possible to have a checkbox that is if shipping is same as billing it would...

After much long hard thought I have decided to just change the current forms in my DB project and condense them into one form as recommended by some very helpful individuals on these forums. I currently have one form to add new orders which fills in my tblOrderHeaders with the orderid...

I'm not sure if this is the right place for this post... If not i'm sorry! $2.00 for first item $0.25 for each additional these amounts are variable depending upon the shipping method picked How would I calculate this I'm thinking with a count of the items.... Maybe?:confused:

I have spent much of today trying to create a subtotal in a subform then displaying it in my main form I have tried almost every suggestion on here and I keep getting a name error on the main form... I know the reference is spelled correctly in my subform I have in the form footer a textbox...

I have spent a while searching this issue on here and it has led to additional questions... Is it better to calculate the tax per item or on the entire order? :confused: I understand that because the tax rate can change that this calculation is justifiably stored but that leads to my next...

How do I get Access to refresh automatically after a command is exicuted?

In my access class I took the Prof said to create a table with the states in it and give each state an ID number, store the number in the fields and use a query and relationships to she the abbrevation when needed like in forms and such but when I try to make the relationships it makes a table...

First off I'm sort of a newbie, I mean I have made some very basic databases before but I am now in need of a more advanced database. So please be patient with me :D ok quick overview of my needs: I need a database to control my inventory and allow me to create and email invoices. My product...

good day everyone! My name is Nicolette and in new to access so i just want to say thanks ahead of time ;-)