Recent content by versuviusx

ok so i have a table called customer table and a table called credit card here is the customer table: CustomerID* firstName lastName city state email phoneNumber here is my credit card table CustomerID* creditcardNumber ExpirationDate SecurityCode NameOnCard CardType ok so here is my...

ok currently i have a table with these fields: CustomerID firstName lastName Billing address city State PhoneNumber EmailAddress Sex Username password ok my question is what kind of field should the CustomerID be? should it be autonumber or just text the reason i ask is that if i use...

ok so i'm trying to make a database for a computer repair buisness i have a bunch of tables but i'm not sure about my relationships. basically i want to make a database that captures information about customers and allows me to make specific queries so i can find trends. i'd also like to...

for example lets says i have 10 records. well it will try to put all the 10 records all on one page. i just want to have each page have 1 record. not 10 records. how can i do this?

ok so i have some data and i want to make a report. the problem is that it puts all the data all on one page if it can. i need to know or find a way to seperate the data by pages that way we can print different pages according to the data. any help would be awesome.

here is the code for the print icon so basically i have the code nulled out but i think there is a way when i click on the print button i can control what i want to print. i need the code for example for something that would output something like Drawer = *Gulf American* and i was thinking that...

ok so i'm trying to print some values in access. i'm really new with it so i just need a little help. i have a dropdown list and i have put in my values for it manually by making the source a value list and then just manually putting in my values when making the table. so i have this form and i...

hi everyone i'm super new at access. i think it's neat for now. i just made a form that people can use to insert information. we have a network drive here and it would be super cool to be able to convert the form into an Executeable file that way people can just click on the exe Icon and open up...

paul i'm declaring the strIncidentDate as a string. the name of the dropdown box that contains the date is named:IncedentDateTxtBox. my code looks right but i do not know why it is not showing up. after i make changes i save all my stuff and then i send my self an email through access. then i...

for some reason my dates are not showing up in the emails that i'm sending to my self. any reason. i have a text box that has a date format and i made it a string. am i gonna have to convert it from something to a string so it can work?

awesome. it would be nice if there was a little book that showed all the shortcuts. often i find there are books that show this info but it's cluttered with all kinds of blah blah and it takes for ever for me to get through it. also i find they show examples but they are not clear because they...

paul you are the man. i haven't done this stuff in a while and i need a way to refresh on all this stuff. it's kind of fun. i like it so far. but it's only fun if you are making progress. once you get stuck for days on a problem...man does that Suck. thanks again man david

formatting the way the information looks also how do i format the way the information looks in the emaiL? for example i have this code: strMessage =strIncedentDate+ strComplaint+ str+ str well i want the email to look like this: " 11/1/06 computer didn't work low priority" basically i...

awesome. thanks so much for that help. for some reason that worked. also how do i comment stuff out in access with vb. i've tried ****** and /////// and those don't work. i want to be able to have comments for documentation so later on someone can come through the code and see what i have...

ok this project is for a help desk. if a user has a problem with their computer they fill out a form and then send an email to the helpdesk guy being me. i got it to work but i'm trying to make improvements. basically i get an error that says" you can't reference a property or method for a...