Search results

This is an alternative way to go: http://www.mrexcel.com/forum/microsoft-access/248191-tutorial-access-menu-permissions-system.html

cross posted at: http://www.accessforums.net/programming/converting-dates-into-week-numbers-custom-38283.html

bratwurst dipped in

Time to post a sample database so that it can be analyzed. Click on the Go Advanced button in the quick reply window and follow the wizard.

You appear to have combined the TransferSpreadsheet and the OutputTo functions Here is the syntax you need to use: which I believe in your case would be

Try changing the DoCmd.OutputTo line to a DoCmd.TransferSpreadsheet line. Here is the syntax for that command http://msdn.microsoft.com/en-us/library/office/aa141565(v=office.10).aspx

cross posted at: http://www.accessforums.net/programming/exiting-access-produces-error-depending-how-started-38218.html

I have nothing against cross posting. Forums however, prefer that you at least identify it when you do it. I don't think that anyone in the forums is looking for it. When I see a cross post, I identify it to help potential volunteers know that someone may have solved the issue before they...

Substitute your field names for txtcurrent and txtnew into this template. Private Sub copyrecordbutton_Click() On Error GoTo Err_copyrecordbutton_Click Dim txtOld1 As Variant Dim txtOld2 As Variant Dim txtOld3 As Variant Dim txtOld4 As Variant txtOld1 = txtcurrent1.Value txtOld2 =...

Cross Posted http://www.mrexcel.com/forum/microsoft-access/729678-reading-db-file-information.html Please read this on crossposting: http://www.excelguru.ca/content.php?184

Cascading Combo Boxes is the term you need for this exercise. Look at this link. He provides two methods to achieve this. http://www.fontstuff.com/access/acctut10.htm

Can you provide us with information on your database. Tables, Fields, etc. Without some knowledge of how your database is set up, I don't think any one can provide you with a good response. After all, we don't have crystal balls. The moderators took them all away and we have to deal with...

Cross Posted at: http://www.excelforum.com/access-programming-vba-macros/956903-type-mismatch-when-exporting-query-to-excel.html Please read this: http://www.excelguru.ca/content.php?184

Does your query run with out the Type Mismatch error?

Look at Bob Larsen's site here: http://www.btabdevelopment.com/ts/default.aspx?PageId=10 He has provided several options for this issue.

Ok. I think that this will do the trick. http://www.tek-tips.com/faqs.cfm?fid=3619

Why not have the record source for your report be a query that you can set the criteria in the Cat field to Yes.

From what I read on that page, you need to import or export through Excel. You cannot go directly from/to Access and Quicken. I thought the link was very clear on this. Did you read something else? Or did you just not see this?

this should be helpful http://www.pcreview.co.uk/forums/import-qif-file-into-access-t3909446.html

Look at this link on database structure. http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx