Search results

It is in the top-level already The database get's used maybe three times a month, so would a auto-compact on clos ein the BE be sufficient? (If so how do I avoid it saving a copy everytime?) The BE is ACCDR, does this still work with auto-compact at close? See above. I have no control over...

Hello, I have a database where users have locally installed a 2007 or 2010 front-end (FE). The back-end (BE) is on a file-server accessible by all users. Unfortunately the network connection is not always the best, resulting in possible interruptions during a write operation. Which then causes...

I think the servers must have reset connections over night. At least today I was able to delete/rename the file after I refreshed...

Hello, I have an application in which the users have a local front-end (FE) Access database (in runtime) that connects over the company network to a back-end(BE) database. The BE is saved on a (file-) server in accdr form. While this is no good protection for a database it should be sufficient...

It is a single file, which is access by only one user. My theory is that it has something to do with the fact that the database is saved on a network drive. Though the whole database is only 6MB small. The data as well as any querries, forms, etc. is 100% fine.

Howdy, I have a Database that all of sudden lost all VBA code and the references to the libraries. The stranger thing is that there was never an error message. I had the same thing happen to me in other databses as well? Any ideas?

But to your original comment, I would advise to create a report (based on the form). With the push of a button you then open the report for the selcted record and send it to the printer. I don't remember teh full code for this, but I know I have it in a database at home. Let me know if you...

Before you send it to save as a PDF you need to apply a filter to the form. Filter for what you want to print (current record) and you are all set.

My train of thought would be to have clients managed by groups. You can then assign employees to that group. For example: Client: FastSpeed Co. Managed by Group: PPM Group: PPM Employees: Peter, Paul and Mary The assumption I ahve is also that clients are shared becaus or regional or...

Joe, did you try VBA code using the ADO method as described above? What is the problem with that?

Why don't you use: DoCmd.RunSQL instead of myDB.execute you also may want to turn of the notifications.

It really depends if you wan to have a running balance. If so you could: - Take the data into a recordset - Make sure that recordset is sorted by date and time - go row for row in the recordset to calculate the running balance - write the running balance in the table

My first thought is that you need VBA code that runs after every line entered and posts the value hardcoded into a table. Menaing you enter row one, then trigger the vba code to calculate the current balance, post it into a field. you enter the next row and once you are done you triger vba...

I forgott to END IF in my code above. But I tested it and it worked fine.: Dim x As Integer x = 1 For x = 1 To Me.TotalSeats If x < Me.TotalSeats Then [Forms]![Table1]![Table2 subform].[Form]![Seat] = x [Forms]![Table1].[Table2 subform].SetFocus DoCmd.GoToRecord , , acNewRec Else...

Yeah, I forgott that your form basically creates a new record automatically.

Did you try to move the: DoCmd.GoToRecord , , acNewRec under here: For x = 1 To Me.ClassSize You can use the IF :

OK, I solved a part of the riddle myself. My idea was that data is entered in sequential time. The problem is what happens when you miss a line. Therefore I created VBA code that does the ranking, thereore you can enter times in arbitraily order: From here on out I can do the cehck from...

Normaly data is stored in tables, so I am not sure why you would want to copy data from a form to a form? If you want to extract data from one table and save in antother you can use a SQL for a append table querry in VBA. Anyhow, I would stay away from Macros and do coding in VBA. Even...

In the loop you would then use a SQL statement to create your recordset in usage of the looping variable. If I am not wrong you can also use ADO (but I still struggle with that).

Hello, I am trying to find the most efficen way to validate the entry in a field based on the previous recordset. The idea is to log time and activity. The form as a header form with the date and a subform in datasheet view. I want to make sure that the subform taes time (for the specific...