Recent content by danielgraham

What i would like is a textbox on a form with a button called run. in the textbox i can add multiple sql commands and run them in order. please help

Done Dim strSQL0 As String Dim strSQL1 As String Dim strSQL2 As String Dim strSQL3 As String Dim StrSQL4 As String Dim strSQL5 As String Dim strSQL6 As String strSQL0 = "CREATE TABLE MoP([MoP] long, [Description] Text, " & _...

well. i have 22 database's to update. and i wanted to learn about sql

Do i have to tell it thats its end a new statement each line. if so How. Im doing this in a query in sql view. itll create the table and the contents but only if i pass one line at a time...Not bulk Thanks Dan

What i want to do is first create the table then insert this data into it insert into MoP(MoP, Description) Values (0,Cash) insert into MoP(MoP, Description) Values (1,Cheque) insert into MoP(MoP, Description) Values (2,Credit Card) insert into MoP(MoP, Description) Values (3,XMAS Club) insert...

create table MoP(MoP long, Description text) insert into MoP(MoP, Description) Values (0,Cash) insert into MoP(MoP, Description) Values (1,Cheque) insert into MoP(MoP, Description) Values (2,Credit Card) insert into MoP(MoP, Description) Values (3,XMAS Club) insert into MoP(MoP, Description)...

Hi I have a query that pastes fields into another table. how can i get if to stop asking me and just do it thankyou

Sounds good....But ive done it now. works vey well

Thankyou so much. ill try that. it sound like itll work. cheers Daniel

Hello, I have been making a report for a local shop. i have made a query for day to day view and its perfect except one thing. numbers to text. i need to convert: 0 = Cash 255 = Cash 1 = Cheque 2 = Credit Cards 3 = XMAS Clube Please help

OK, But i dont understand. say i have 128 days of data. in the query i only want it to see 100 days of data.(Hide the last 4 weeks) where do i make the query and how would i delete all data after making the data. thanks daniel

I dont understand. ALL I WANT IS TO PRESS A BUTTON AND I WILL DO IT. OK. I HAVE ADDED AN ATACHMENT. PLEASE HELP DANEIL

Ok, I have a databse with dates when the data was set up. now the database is getting to large i would like to have a button that says export data. that will export data to a second database and delete the data it exported that is in this one. but i would like it to have 28 days of new data all...

Hi im making this database that cand at any day you can select a discount. so i want to selected 300 records and give each price 10% discount. one only problem. i dont know how :confused: :confused: :confused: please help

Hi i have searched for this but could not find it. i would like to create a form that will manage my linked table and i call relocate the database with it as well. thanks