Recent content by dreamz

Thanks, Will give it a try

Hi I have a form that gets smaller when clicked on. I have created the form in Access 2007. I do not have this porblem on my pc but on another pc that the application was created for. The form itself doesn't minimize but the contents just keeps getting smaller and smaller, like someone zoom's...

SELECT B12 FROM TK3000 WHERE (((B12) Is Null)); returns the blanks and non blanks

Hi Have a problem with the Is null statement/criteria in access 2007. If i put the Is null criteria in, it returns 1 row (there are alot more blanks) If i return all the records and filter for blanks, it returns 200 rows. What could the problem be?

Okay so i'm trying to get this to work. I copied the code, changed the form and title name but it keeps saying error. any ideas? Error = Expected End Sub I havn't used access in 3years so i'm rusty.

yes it's wrong to do that.....blah blah blah but if u were to do it... As Hi tech coach said... Append query works. Then create a macro that runs the append query... and your check box will run the macro. HTH

Not sure what to call this but i can explain it. I have a form. Data from the form is captured from the table. I have a submit button which triggers a macro and captures the record. Problem - If you capture anything on the form and don't press the submit button and close the form, it still...

They not identical tables. Some fileds are the same. Table 1 - Name, Surname, Age, Comments, blah blah blah Table 2 - Name, Surname, Age, Question 1,2,3,4,5,6, ect.... So some fileds are the same and i'm trying to save time by entering the same information in twice. Unless you can suggest a...

I have the same problem. What i'm thinking of doing is creating a query to update Table 2 from Table 1, then on my form have a submit button that when pressed, enters all the into into Table 1 and runs the query that updates Table2. Unless anyone has a better/easier idea?

I have 1 unbound TextBox, which i use to select the File i wanna import. So i open the form and select the file. I then Click the button that runs the macro. Now i have to do it again for a different file, to do this i have to select the file with the unbound text box again and click a...

Only have 1 unbound text box that i'd like to use to import 10 files. I have setup the queries to be universal, so they'll run with all the files, but as opposed to having 10 macro's with 10 buttons to do this, i'd like to have 1 macro running in a loop. what i need now, is a way of telling...

Hi i currently have a macro setup with the transferspreadsheet function in it and it goes a little something like this.. Table Name - abc_def_ghi_jkl_m File Name - =[Forms]![import_frm]![txtfile3] Has Filed Name - Yes Range - abc_def_ghi_jkl_m now this works but what i need is, to be...

O2 XDA IIs don't use it much ne more though. mostly as a phone & sometimes to surf the net.

-*bump*- ne 1?

thanks :) i'll tell you what the logic (if u can call it that) is behind this. i've created this db and everything is automated, so in 3 clicks it imports the new files, rund the query's and exports the files. i need to hand this over to a user to do so i don't have to run it everyweek...