Search results

Is there a way to avoid having someone open an fe/be database and locking it up? I'm not exactly sure what causes this, but sometimes when I try to open the front-end of a database, it won't open and instead just goes straight to the Access program. When I try to open the back-end directly, it...

I believe I have figured it out. Thanks for all your insight.

Well, I'm probably doing something wrong, but that adds another entry to the table. What I want is to edit an existing record with the login information.

I know this should be simple, but I have a table of database users and I want to save the last login date and time every time they log in. I know I can edit the table with the .Edit and so forth, but how do I position the pointer to the proper record so it won't just write to the first record...

No ideas on this one?

I told you I was an idiot. Thanks for your help. Works like a charm when you do it right!

I tried that, but I'm missing something, because it still just does one column.

I know this is an easy question, but I am apparently brain-dead today. I am trying to make a columnar report in Access 2007. Just two pieces of data repeated across a page about 4 times. I haven't done this in so long, I have forgotten how. Any help would be greatly appreciated. Thanks.

Is there a way to be able to select mutiple items to group a report by?

Any ideas on this one?

Anybody know of any bug issues with pivot charts in Access 2007? Every time I try to create a pivot chart, I will get so far, then it gives me the error screen and shuts down Access. Any ideas?

I have a form that has a combo box of fields to choose for grouping a report. The users want to be able to group by more than one field at a time. Is this possible? Here is my grouping logic attached to the run button: If lstGroupBy.ItemsSelected.Count > 0 Then strIDs = ";"...

Still having a problem with this one. It appears when the 2007 runtime is loaded on a machine with an older full version of Access, the programs use the Access 12 object library, and I cannot change it.

I have placed it at the bottom, but I am still getting the error. Any other ideas?

This is what I have in my startup form. The red text is my code that was already in the startup form. Perhaps I'm doing that part in the wrong sequence? Option Compare Database Option Explicit Private Sub Form_Load() Dim strFEMaster As String Dim strFE As String Dim...

I am trying to incorporate this utility into my database, but I seem to have a problem with the runtime version of Access 2007. Any ideas on why that may be? I will try to attach a shot of the error I am getting.

Here is a strange problem happening on a couple of machines at my workplace, but not all. I can lauch an application off the network if I go directly to the network folder the application is in and launch it that way. When I create a shortcut, either within the network folder or on the...

By jove, I think you've got it! Thanks.

I have an interesting scenario here (at least, interesting to me). I have a maintenance work orders database that will send an email to the engineers when a person fills in an Access form and clicks "Send email". The database currently sends the email to the engineer selected as well as a night...

Sorry to cause the headache. I should have realized that earlier. I knew the field was locked because I don't want anybody to be able to edit it. I did not know it would affect a query, however.