Search results

here's a weird challenge guys.... is MS Access overwhelmed with data? my code below DO what I want it to do but when the records jump up to 2 weeks of data (like 500 records)...it does not do what I want it to do. example below is the data in my table... I will traverse thru this table and...

XML I'm reading, (I can read it now, and store the value to a string variables) I need a way to insert the data 1 by 1 to a row of a table. ReferenceID: NXX-001 FirstName: Nelson LastName: Smith ReferenceID: NXX-002 FirstName: Johnny LastName: Cash ReferenceID: NXX-003 FirstName: James...

Basic QUery with Parameter taken from text field Hello guys, I've done this many times but somehow this one does not work...am I going insane? Dim sql01, sql02 As String sql01 = "SELECT * FROM CPOrganisation " sql01 = sql01 & "WHERE (((CPOrganisation.DateEntered) Between #" &...

hello guys... is it possible to search a query results ? The reason for this is that I need to only allow the users to search on advice records where General = "Yes" and Private="No" , I have a working query that filters our all General field ="Yes" and Private="No" , not I need to search...

I'm sure this is basic for everyone but I forgot how to lists all the records except 1 record. SELECT * FROM table WHERE ???? hmmm im stuck. Thanks in advance! :) The table records advices made by users. it has Author, I want to list all advices except the one the author made. thanks

hello guys, I just need some opinion about the code below: tbl contains these: uid owner private uid=getOSUsername ' current user txtOwner= thru SQL , retried owner of a particular record txtPrivate= thru SQL, get value if owner set the record as private if uid = txtOwner then if...

is there a way to say I enter a date on the date field in a form, and when I hit the report button, this report will grab that data from the date field and include it to the report. thank you in advance.

Hi, can anyone here give me some hints/tips how to fix this problem....at the moment, I have this code below to retrieve the informations from another table (this table contains imported XML data thru ASP coding)... what happened is the ASP programmer didn't follow my specification and made a...

I have a table and it has: namefield surnamefield state1 state2 state3 match(Y or No) importDate I would like to make a query+ report so that in the report it looks like this: <<Name>> <<Surname>> <<state1>> <match> <<state2>> <match> <<state3>> <match> in one line, at the moment...