Search results

I have a table with data as the following ID text CreatedDate CreatedBy 1 my first entry 01/01/2017 Jim 2 my second entry 01/02/2017 Kim 1 my third entry...

I have a table with data Col:1 ID Col.1 1, 2, 3 etc Col2 Fruit Col2 Pear, Apple, Orange Col3 CountofFruit Col3 2, 4, 7 This would bring back 3 rows with the data above. I want to increase the row count based on the countofFruit Therefore, it'll have 2 lines for ID1, 4 for ID2 and 7...

I have a table with a large dataset, with 5 columns which data can change (the first is a unique ID that doesn't change). I am given the same dataset in CSV that I can then import as a linked table which may have changes What Im trying to do is loop through the existing dataset and update those...

I have searched and searched the internet and not found anything that I understand and helps. I have an access db that records addresses, in several fields. i.e: House number, street, county etc. Currently users complete this manually on a form and data inconsistency and accuracy is high. I...

I have a database (sql server back end - access front end) I use vba to open an excel sheet that is already linked to a query in the current DB, when I try to refresh, I get a DB is in a locked state by Admin etc Is there a way to refresh this sheet with passing the data to another DB...

I have a table with start and end dates. I need to build a query to show the next 6 months everything that has: - already started - going to start - that has not ended Then I need to show each line of what calendar week it fits under if it's live. Yes, I am aware i will get dup lines - but...

Hi Im trying to declare a const I have declared Dim strPRX as string. strPRX = "Test" Im using: Const spath = "C:\Users\Jim" & strPRX & "" I Get: spath = C:\Users\Jim\& strPRX &\ What Im trying to achieve is that spath = C:\Users\Jim\Test\ Any help please

Hi - Not sure if this should go under 'General' I'm after a sample DB for Access 2007. That can help me schedule items. I need something with dates across the top with Categories down the side. But each Category could have more than one item under the same date period. Something like this...

I have 3 tables. A person table, a checking in table and a checking out table I want to build a query that brings back one line for a person thats checked in and out for each stay E.g "Person a" - "01.01/2000" - "02/01/2001" "Person a" - "01.02/2000" - "02/02/2001" "Person...

Hopefully an easy one. For example, I have some data and in this data contains a column with fruit. Four rows have apples Two rows have pears Five rows have oranges In the header I want to say there where 3 fruits, but if I use count it says 11 (which is of course right - but not what I want...

This should be an easy one. I have the following code that works perfectly: Dim r As Recordset Set r = CurrentDb.OpenRecordset("tblTableNames") r.MoveFirst Do Until r.EOF If Left(r!tablename, 4) <= "sqlA" Then DoCmd.TransferDatabase acImport, "ODBC Database"...

I am trying to delete data from several tables in another DB - where the table name matches the tables in my current DB. I so far have: Dim t As TableDef DoCmd.SetWarnings False For Each t In CurrentDb.TableDefs If t.Name Like "*" Then CurrentDb.Execute "Delete From T.name In...

I have two identical Databases - one is a Live DB and the other is a Training DB. The data is held on a sql server connected to an access front end. (I do not have access to the sql server). - On each table I have a field called UpdatedOn - On each table every record has one field that is a...

In VBA I have set a timer on a form to run a query and export to a specific folder as an excel file. If I open the database as 'File Open' and open the form and let the timer run it exports perfectly. As soon as I put the database into runtime - the Timer code kicks in and starts running but...

I have an extremely strange problem. I have an access database front end linked to a sql server backend via ODBC . The sql server was a replicated server of 4 up to 27/03/14 and then 3 were decommissioned leaving just the one server. The issue I'm having is if I run a pass through query in...

I have an access 2007 database connect to sql server 2008. I am running a pass though query to search between two dates (this query has been fine for years) If I now run any search using parameters from 26th March 2014 to date - the query takes 10+ minutes to run. If I then change the date...

I am trying to open an excel doc from a command button using vba. I can open the excel file, but because the excel file has a userform on open, access is then locked and I can't even look at it and the excel userform doesn't work correctly. Therefore, Im sure there's an extra step in access...

I have an access database connected to a sql server. How can I export/copy the sql tables into another database as Access tables? Not as sql tables! I could write make table qrys and run them as a macro, but it'll take ages to write 250 qrys to do this. Any help please!!!!