Search results

It's been awhile since I posted here but in the past, all the information I've received here has been top-notch quality and swift. Very professional and very useful site. However, now I've encountered a very odd problem, not with Access, but rather with regard to Wi-Fi networking. I've already...

Access 2013 x86 running on Windows 10 I have a form ("Front") which contains a NavigationControl ("NavigationControl0") "NavigationControl0" contains buttons to select (load) between 3 different subforms: "Welcome" "ImportData" "ExportData" When the "Front" form is opened, the default view of...

Access 2013 x86 running in Windows 10. I'm working on an unbound form named, "Front" The Front form contains a Navigation Control with 4 Navigation buttons. Welcome (click activates the unbound "Welcome" Navigation Subform) Import (click activates the unbound "ImportData" Navigation Subform)...

Is there I can use a built string to refer to an existing recordset object? For example, I build a string "rs_Char4" I need to be able to associate that string with an existing recordset object (.OpenRecordset, .MoveNext, .Close, etc) I've built a function which has a parameter "rsToManage as...

I have an Access 2013 database I’ve built to assist managing membership for our club. Currently, all tables (not large) are contained in the same database as the front-end forms. Ultimately, this database will need to function on multiple laptops and/or tables so I’ve always known and planned...

HI All! Long time no see. I hope everyone has been well and fine. I find myself needed help creating a custom VBA function in Access (2016). I need to convert the add-in load time values stored as binary registry keys in the registry to decimal values. A few sample values look like this: 05 00...

I have two tables, both with identical structure but different contents. 153 Total fields each 710 records in one and 791 records in the other. Field 0 = RecordID = AutoNumber Field 1 = File_Date = Date/Time Fields 2 through 152 are all memo fields Field 153 is "File_Name" = text I created...

I am using Microsoft Server Manager 2012 on a VM. I am able to create a server on the VM's local C:\ However, I am now trying to create a new server on a network share. when I get to the "Instance Configuration" step, I enter the path. I receive the error: The path...

Ok, I'm embarrased to admit this, but I am stumped. I cannot get the object properties window to appear in Access 2010 (x86) running in Windows 7 (x64). I select an object (lable, button, text box, etc), right-click and select "Properties" and nothing. In the "Design" section of the "Form...

Hi All and sorry to bother you with what may prove to be rather obvious to you but seems to be escaping me. For reasons I need not get into as it generally proves to be a distraction, I need to document the relationships in databases. I've been playing around with .Relations with some success...

Does anybody have any old code snippets you've used to open a Workgroup restricted MDF file using VBA. To be clear, this is NOT via ADODB or DAO. This needs to be within an Access.Application Object. I have code that uses objOrigin.OpenCurrentDatabase just fine for any unprotected database...

Ok, I’m stumped. Connecting Access FE to SQL SERVER BE Connection is fine. I can open and close it and other queries work fine. I have only one problem with the SQL in one queryWith rstRPT If FirstRecord = True Then .Open "SELECT Min([" & SourceTbl & "].[3Order ID]) AS MinOf3OrderID...

Lets say you have a table with an AutoNumber field You populate it with 100 records You delete the last 10 records (91-100) Now, I certainly know you can refresh the AutoNumber sequencing by compacting the database so the next record entered is 91. HOWEVER, THAT IS NOT MY QUESTION My question...

I have some code that successfully gathers some items and adds these items to a listbox, one item at a time using .AddItem And it works ok. The problem is, when there are a bunch of items to add, everytime the .AddItem runs, the form redraws. I don't mind this terribly when there is only a few...

I need to get a list of all the Win32_OperatingSystem properties and their values on various different platforms. I’ve done some reading and testing and afraid I’ve hit a brick wall. Running Office 2010 (x86) on Win7 (x64) I’m able to get the Key Property value for the instance, but then...

Hi All, I'm pretty sure i know why this is happening, but I cannot seem to sort out the solution. I have the below code. It is running from Acccess 2010. It runs fine, the first time through. Then it errors out on the red line on the second loop. Private Sub...

I created a blank ACCDB in Access 2010 (x64) running on Win 7 (x64) It is saved locally. I created a blank, unbound form. I created a generic button (with no action associated) and then copy/pasted it several times. I clicked into each button and changed the VISIBLE caption. I opened the...

We are performing migrations of all Office files from the older formats to the newer formats. We have an automated tool which, in addition to converting the format(s), reads the VBE projects and performs remediation of the existing code for deprecated objects, methods, and constants. To perform...

Hi All, Are any of you Access Gurus handy in Excel? I'm trying to solve a problem described here: http://www.access-programmers.co.uk/forums/showthread.php?p=1298448#post1298448 The code and eventual functionality should/could/would likely end up being very similar to that which would be used...

I have another thread here: http://www.access-programmers.co.uk/forums/showthread.php?t=254429 Please excuse me if this seems to be a duplicate thread, but I fear the other one may be taken too literally as being specific to the connection method there described by the existing VBA provided...