Search results

Thanks. If I disable the shift bypass, how do I then allow the DB administrator to view Nav Pane, menus, etc. This database is FE and defaults to Form view only on open.

Apparently, holding the shift key down while opening an Access database prevents the 'Autoexec' from executing. How do I force a password entry if the user is smart enough to open the database while holding shift key down? Thanks.

Never mind. Found my problem. VBA code was not in a module but in a Form class module.

I have a split database with an Autoexec macro in both the FE and BE. The VBA function that is executed exists in both FE and BE. The macro runs fine in the BE but gives error in FE: "the expression you entered has a function name that Microsoft Access can't find." Are FE macros allowed?

Let's say the student retakes the course and gets a new grade. I only want the last grade achieved. In your outline, how would that be handled? Find existing record, delete it and add new, or find existing record and update it? Sorry for the questions. Just a beginner.

Thank you. You're right. By course changing, I meant that the courses available to the student may change, so enrollment would change. So, instead of recording all of the course grades in a single student record, your suggestion creates an individual record for every student/course/grade. Is...

I am setting up a student grade reporting database. There will be a Student Master Table (SMT) which will contain personal information about each student, including a unique Student-ID. There will be a Course Master Table which will contain information about each course, including the name and...

Thanks. I will do that.

Hello all, I'm developing a database for recording student grades. What's the best discussion group on this forum to ask design related questions? Thanks.

Thanks again to everyone. I'll recommend that the back-end be distributed to desktops. Only problem is, I see another app down the road where distributing b-e is not feasible.

Thank you all for your comments and suggestions. I am going to add more information because I'm hoping to hear different or at least more encouraging comments regarding using this method of sharing the back-end. The front-end of this database will be distributed to end-users to their local...

Thanks. This is a back-end database and it is only used to retrieve data by a select query form by a few users. The back-end will be updated by only one person quarterly. Do you still believe this is not a suitable location for the database?

Here's what it looks like. The server/service is something called 'Egnyte'. It's enterprise storage that you rent and where you can do file sharing.

OK, I think it means someone is using the database. I'm not going to worry about it. Case closed.

The back-end is on a cloud server. That's where I get the message. When I link to back end on local NAS, instead of "This recordset ...', I get 'Datasheet view', which is what I would expect. Also, when I see the 'Access' symbol to the left of the file name on the cloud folder, there's a...

Can someone please tell me what this message that I get in the status bar means? I was not getting it and now I am. I'm dealing with a name search form that does a requery to populate a list box on the form. The database is not read only. It does not appear to affect the query results. Thanks.

Zip code field is last search box on form. I used this: Private Sub Zip_LostFocus() runSearch End Sub so if the user enters 'Zip' box and tabs out, whether entering data or not, the search starts. Everything seems to work. Thanks to all.

This is what I found elsewhere: Private Sub fName_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyReturn Then Me.Refresh MsgBox 1 runSearch KeyCode = 0 End If End Sub It's what Uncle suggested and seems to work. Do I still need to set...

Need some help, please. I have a name lookup form with several search argument boxes; e.g., address, state, zip, etc. I do not want to initiate the search program with a 'Search' button, or when the user enters an argument and then tabs to the next search box. I would like to allow the user...

Doing 'DoCmd' select query so 'recordsaffected' won't work. Thanks anyway.