Search results

Hi, just posting here instead of makingnew one as its a follow up, I am running an SQL command in access that returns ObjConn.Execute "select * into tblMain from dboMain where DateCreated BETWEEN #" & CDate(strDateC) & "#" and #" & Cdate(strDateC1) & "#" Both of these work if i do a...

lovely stuff, thank you :)

Hi, I have a textbox for the User to enter a date, i want to then retrieving the records from my table which have a date within a month of a textbox date, so say i have a text box return: strDateC = txtDateC (e.g 10/01/09) strDateC1 = **txtDateC + 1 month** (e.g 10/02/09) Im...

My apologies, i did state at the start that i wasnt sure if this is the right forum to post in.

This is using PLSQL, not sure what additional details i can provide but please ask. Every table with a name beginning with A has a column called REFERENCE in it and you should be checking that column for a data value of A01? That is indeed the case. I need to delete any records in all...

Hi, mines more of a theory question, im not sure whether this is the correct section to post in. Would it be possible, to search through a large amount of tables, and for any table that begins with A (say theres 100 tables that begin with A), delete any row that has a REFERENCE cell value of...

worked a treat, thanks :)

Hi all, This is most likely a minor error on my part, Im trying to retrieve records from a column where the date is greater than 1st December 2008. I have 6 records as 05/01/2009 so this should work. Ive tried '01 December 2008', '#12/01/2008#' and '#01/12/2008#' SELECT Name, Age FROM...

My apologies, i wasnt aware that you could as some 2000 commands dont work in 97.

Hi all, I have a database in Access 97 that, when trying to compact or make into an MDE, gives the following error: "Error: Record(s) can't be read; no read permission on 'C:\DOCUME~\johnson\MYDOCU~1\DB.mdb" I decided to make a copy of this database and then emptied it of all tables /...

worked a treat, thank you :)

im aware of the and statement but it wont work in my case, i basically have: If searching_ws.Name <> "STAT" Or searching_ws.Name <> "BASIC" Then maps_ws.Cells(maps_ws_row, 5).Value = searching_ws.Name maps_ws.Cells(maps_ws_row, 6).Value = searching_ws.Cells(foundCell.Row...

Sorry if this is general knowledge, i cant find a suitable answer for me. I need an if statement with 2 clauses before moving on, like this If searching_ws.Name <> "STAT" Or searching_ws.Name <> "BASIC" Then but know this to be incorrect syntax, i believe it would work with a If...

Hi all, I have an Access App which ive decided to trim down for storage, it was 2GB though ive emptied tables, just to retain the code, the size is no different. I then cleared everything (tables/modules/Querys) leaving it blank yet still shows as 2GB. Why? Many Thanks

yeh sorry your right, it works now, thanks for the help :)

the module is called NewImages

Yes it is in a standard module

Thanks for the reply, it accepts the function name, but when i close the tool and open, i get this error: "the expression you entered has a function name that ViewerDatabase can't find" ViewerDatabase si the name of my access database.

I have a module created that will update a table(TEMP) with the names of folders stored in a file. I want this code to be ran once the access database is opened. Public Sub NewImages() Dim fso As FileSystemObject Dim folder As folder Dim f As Variant Dim rs As DAO.Recordset...

Hi all, I have a table that is supposed to contain 7 character values however some are 6, and some are 12. The 6 character values dont bother me but the 12 character values are the 7 character correct values with 5 leading zeros. Anyway i can trim this? there should be no 0's at the start of...