Search results

I am trying to run a query in Access 2010 but I am getting an "Invalid Procedure Call" error. I searched online and found that this error can be caused by broken references. I opened the VB editor (Alt F11) to search for "Missing" references but I do not see any. These are the 4 that are...

I am working with two spreadsheets that I have imported and would like to know if there is a way of finding matching data between two columns. The tricky part here (well for me anyways) is that the columns have similar data but one has a period separator with an extension value that I want to...

Hi, I've been using MS Access 2007 for years to manage some Excel data. running some queries etc. Just recently I've been encountering problems when importing data into an existing table. When I do it now, I get a "Subscript out of Range" error. To troubleshoot, I imported into a new table and...

Hi, I have 3 seperate spreadsheets containing server information. There is a column in each of the spreadsheets with a header called hostname. I import the 3 spreadsheets and create 3 seperate tables. Table_A Table_X Table_Z Table_A acts as my master table. I would like to run a query to...

Hi, I would like to hear some suggestions regarding the best way to learn SQL. I am not from a programming background but I know a bit of VBScript for systems administration purposes. I own Office 2007 and use Access and Excel. I know Access has alot of SQL functionality but I have never used...

I have a database that contains a list of servers along with other fields such as contact numbers, server function, joined domain and others. One of the fields containing telephone numbers was accidently deleted by user error. Fortunately I have a week old backup of the database still containing...

Hi, I was wondering if there was a way to change the default path when you are in "Get External Data" - "Specify the source of the data". The default is My Documents but I would like to change the path to open in my commonly used folder.