Search results

I recently took an Access online course and was given a way to make a database "user friendly" that didn't involve any code. I'm not sure if this works better or worse than coding or saving as a different file, but I'll share what I've done. When you're ready to turn your database over to the...

Of course! Thanks for reminding me of that option! Worked like a charm.:)

Still having a few issues. I should include that my database is split with tables in a back end file on a shared network drive and a front end on each PC (there are 3) that access the data in the tables through multiple forms and queries. The code I tried yesterday is working and my form...

I tried the code you posted and it seems to work. I have opened and closed my database several times and the form loads a new record each time I click it. Also, I'm not getting the Parameter Value errors for the controls on my frmFoodReports form any longer. Could that code have been...

I will try that code and see what happens. I am new to VB. The only other code I have worked on is for a different form, frmFoodReports and looks like this: Private Sub btnResetFP_Click() Me.cboFPNum = Null Me.txtFPLot = Null Me.cboFPFormula = Null Me.txtProdBegDate = Null...

I am using Access 2010. I have setup a Navigation form (Navigation) and several subforms. On one form, Create New FP Sample, I have entered the following code to have it load a new record. Private Sub Form_Load() DoCmd.GoToRecord , , acNewRec End Sub However, when I open the database, this...

I'm having a problem in Access 2010. I have only been using Access about 6 months and know nothing about programming VBA or SQL code. I have looked through the Macros and Expressions but I'm not very good with those yet and haven't found anything that looks like what I want. I have a table...