Search results

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

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?

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

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

Hi does anyone know how i would make my database compact & repair itself either when i open or close it? tried to do it via a macro but it says that it can't compact and repair when a macro is running :( :confused:

Hi How can i export my file using the macro (transferspreadsheet function) but export the file with the current date. so if the filename is gonna be fhm.xls, i'd like it to be fhm09-01-2006.xls.

Hi I'm trying to import a sheet from a excel spreadsheet. this is my "code" The problem is that when i hit the run button, it imports blank sheets or more likely is not importing at all :confused: :( On Error GoTo ErrorTrap Dim dlgOpen2 As FileDialog Dim countrystring2 As String...

hi i've created a unbound text box and for my default value i've put the path of a spreadsheet i wanna import. How would i get my macro to select fromt the form as apposed to the default path i put in manually.

Hi i've managed to create a macro that opens a query into design view but can't seem to figure out how to get the macro to run the query :(

I have 6 Queries that i would like to Automate to run with a click of a button or 2 or 3. The db needs 2 tables to run which i'll need to import. Can anyone help me out. Tell me where i can begin or where i can find out more about this. Thanks in advance Rayan

Hi i need help using the "IF" function i think. Basically i have 2 "columns" A B aaa aaa aaa aaa Basically if i have say Column A that has some fields filled in and Column B...