Search results

Hi, all - I recently revised an A2003 database to 2010 and am now using the navigation type of form. In two of the second level tabs in the navigation form, I am getting strange form/subform behavior. 1. The first tab opens blank; no form shows at all. If I move to the last tab then back...

A simple solution worked. Thanks, Galaxiom.:)

Thanks for your reply. Actually, in this situation, the field value referrs to an autonumber in another table but in the table that is being searched, it is a regular integer. Not sure if this makes a difference.

OK - Worked this time. Thanks.

Appologies - hope the edit is an improvement.

Hi, all - I am modifying an existing database and replacing an early text field with an autonumber. The field name is the same as previously with with the values and data type being different. The field in question is PTID In the previous version, I had code that worked fine to determine...

Thanks for your replies. I was able to get it to function.

Hi, all - I recently modified a older database and recreated some lookup combobox fields in some forms. I used the combobox wizard and selected the third option - "find a record on my form..." When using the combo box to look up a record, the record will appear and quickly disappear. I'm...

I am considering putting a backend DB in SharePoint Online. I did a test and it seemed that it is required for primary keys to be numerical. I have had some simple reference tables that didn't use a numerical/autonumber primary key. Am I missing something or is this correct? Is there any...

That did it--thanks!

Hi, all - I'm getting "Compile error: Method or Data Member not found" when running a simple code. Here's the code: Private Sub btnOK_Click() Dim rs As Recordset Set rs = CurrentDb.OpenRecordset("tblEmployeeList", dbOpenSnapshot, dbReadOnly) rs.FindFirst "UserName='" & Me.[txtUserName] &...

Hi, all - I'm looking to use SharePoint for my Access backend although database users would have a regular front end application. In doing a test, SharePoint didn't require a logon for the back end to be accessible through the front end application. Does anyone know if users should have a...

Thanks. Just to be certain, how about mdbs with user level security?

Thanks for catching the typo and for your response. How about opening an mdb file?

Hi, all - I did a quick search but didn't find what I was looking for here - What's the bottom line on Access 2013 opening .mdb or accdb (2007 or 2010) files? Will projects in those formats work in Access 2013? Thanks!

That would help, for sure. I've stripped the database to manageable size, removed data and attached it. The quirk is still occurring. thanks.

Hi, all - I am converting a 2013 database to 2010. I am recreating forms that were accessed via button controls in menus to 2-level navigation forms. I have two forms initially that used the same subform and what had been accessed separately are now two tabs in the 2nd level of the current...

Sorry for the delay in my response, jdraw. I'll check them out. Paul

I realize I don't know how to use "Smart Identifier" to use indents. If someone would tell me how I'll redo it. Thanks.

Here is the complete routine: Sub AuditChanges(IDField As String, UserAction As String) On Error GoTo AuditChanges_Err Dim cnn As ADODB.Connection Dim rst As ADODB.Recordset Dim ctl As Control Dim datTimeCheck As Date Dim strUserID As String Set cnn =...