Search results

Thanks Bob. I was using that to validate the version of Access on the system before I tried to open the database (had one customer wondering why my application wouldn't work when it required Access 2007 but they had Access 2003). Looks like I've got a bigger issue than just that one since I...

I have the following function that is supposed to return the full path to MSAccess.exe. It works fine on XP, Vista, Win 7 if they are all 32 bit but its failing on the second call to OpenSubKey and not getting anything back. I've looked in the registry for the sCLSID returned from the first call...

Currently my access application runs with Office 2007 and expect some of my users to start migrating to Office 2010 after the first of the year. Problem is, I need to support both at the same time. I currently have references to Excel, Word, and Outlook in my VBA. Anyone have recommendations...

I needed to write a comaddin to be able to read information from a web service for my Microsoft Access application. In my form_load() sub I have the following code to make sure the addin is loaded and it gets synched up with the controls on the form: With COMAddIns("myAddinName.Connect")...

The form doesn't refresh until after the code is done so you only see the last value. If you want to refresh the whole form do: Form_MyForm.refresh But you probably only need to refresh the field you've updated: Form_MyForm.MyField.Refresh Hope this helps. -Lution

I've added a reference to a vb.NET .tlb file. One of the methods in it is: Public Function getMessageList(ByVal agency As Agency) As <System.Xml.Serialization.XmlElementAttribute("receipt")> Receipt Dim results() As Object = Me.Invoke("getMessageList", New Object() {agency})...

Thanks for the reply Banana. What I was trying to say, is that it seemed weird to me that I'd need to create a ADO/DAO connection to get to the database before I could start adding records if I did that part in the vb.NET add-in. After looking at the sample at the URL it hit me that if I want...

I need to retrieve data from a web service. The only way I've found of getting at the service (and its data) is via a .NET add-in for Access. Within the add-in, I've followed the instructions from http://msdn.microsoft.com/en-us/library/aa902693.aspx to tie the add-in to a form in my Access...

It might have, but I'm trying to clean up the data that was added to the existing tables before I was able to add the referential integrity.

I ended up getting the delete using several steps: 1. Run a create table query that added a row for each entry in tblfinancialtransactions that didn't have a matching entry in tbltransactioncase. When I did this query, I had to modify the join link so that it picked up all the rows in...

Trying to clean up some data and I know the solution is simple but its eluding me, even after searching these forums. I have 2 tables: tblFinancialTransactions and tblTransactionCase. The join field for the two tables is intPaymentID. I'm wanting to delete the records in...

Knew I was getting too tired. Right after posting this turned on hidden tables and looked at MSysQueries and looked in the expression field. That helped point me to the field that was referencing a query that had a reference to the old form name. -Lution

I've renamed one of my forms and now I'm getting a missing parameter error and I can't find where the bugger is referenced. Not sure if it is a saved query or part of the data on one of the fields in the form or a subform. Are the queries that control forms saved in the querydefs table and if...

thanks George.

I'm trying to decide on the best way to store a string that represents a person's driver's license number. The format for each state is different so I can't apply a single format to all the values and when I send the data to other agencies they only want alpha-numeric characters in the data...

Thanks pbaldy. I tried the group by but couldn't get it to come out just the way I wanted. I ended up creating a 2nd query with the select distinct with just the name/address fields in it and use the 1st query with the where fields as the input. Seems to be working fine. No idea what the...

I have a query to pull fields to create envelopes so it has name, address, etc. I did this as a select distinct to make sure I only got one envelope per person. Now my users want to be able to apply some criteria to the list, example past due. When I added the criteria fields, it messed up my...

Sounds like a "select distinct" type query. You'd want each distinct name, job description for each person. example: select distinct <employee id>,<job description> from <tablename> Where it gets sticky (for me at least) is if you need to total the number of years at each job description...

I have clients scattered across multiple companies so each company has their own FE & BE. When I have updates, usually I just have UI changes so I can deliver a new FE and everything is good. Unfortunately I also occasionally have to change the BE at each company. I used to deliver the 3rd...

Each client has their own FE and BE. To date, I have a 3rd database that the users run once that makes schema changes like adding new tables, changing column names, etc. Its a .accde with VBA code that opens the BE and makes the necessary changes. I'm looking to move the functionality in the...