Search results

I will paste the SQL string that was produced by your code. try to paste it in to a new query and try to view in design. you will have an alot of errors. INSERT INTO Main Table (Report Number, Rating, Pass Fail, Non Rated, Chief Insp Review Inspection Type, TEC, Date Shift, Time, Inspector...

first of all i would like to tell you that you did an amazing job. right off the bat i see a few things. here is a few pointers: 1. i don't know why you type in "Else" if there is nothing to be done for the else condition. (not so important) 2. what i think you are trying to do is that if the...

why don't you set up a browse button so that the user can choose the location?

I am not sure exactly about what you are trying to do, but i will attempt to direct you with some pointers. 1. i don't think that DLookup(,,Criteria) is correct. i don't think that the asterisk works (i may be wrong on this one). 2. you are using varServer - is this a variable for the directory...

couldn't read your file.

sorry for the delay, but i am wondering if this was resolved. did you try "where startdate = max(startdate) etc.. without using select sam

You can set up the report groupings as if this was a bounded report. you need to type them in (as apposed to selecting them). add the group header and/or footer if you need them. i did some interesting things with this type of report. including totals of all sorts. the only total i wasn't able...

try this: use a combo box and make it have two columns. the data will be from table/query and datasource invoke the query builder. there you can make up your query. you will have two fields selected, first is from tabel1.names and the second table2.names. then create another textbox with the...

sorry bro, sam

hi i decided to take another route, but i wouldn't mind an answer if someone has one. i searched msdn and i found an explanation that may be is still valid. its from 1999. topic: Creating and Modifying Stored Queries in Microsoft Access Databases with ADOX link...

way to complicated. your method seems to be an over kill. just create a query, and in design view create an inner join. you add table1.names and table2.names. in criteria you write Is Null. thats it. i think there is a help file on this. sam

format doesn't return a date (it returns a varient, see help). you need to use something like cdate(format([RemitDate.... sam

Hi I am also new to access, and i am looking for something similar. i would like to save my sql text as a query, i would like to use ADO. can anybody help? i would like to add that i am having a problem. i need to extract totals from a crosstab query and display it to the footer of my report...

Thanks - still not sure Hi First, i greatly appreciate the example, i think it really explains the split function and serves as a real life example. i recommend all to try this example if you need the spit function. (btw, there is a mistake in SplitByComa. strResult(intlElment) should be...

hi i already got the answer on microsoft discussion boards. basically i need to refrerence it a bit different don't ask me why. it works in excel, but when i automate from access i was having problems. see the other post here...

Hi i open a query as a recordset in VBA. i then need to use the split function to split up a few fields. how do i do this for the entire recordset. for example: MySplitVar = split(rst1("Field1")) now i need rst("Field2") = MySplitVar(0) rst("Field3") = MySplitVar(1) keep in mind i can't write...

Hi i am working long hours here, so i really didn't have the time to test and inspect your whole code. i happen to be working today on the same report, and i remembered that there was something missing in the literture that made my report work. i guess it really depends on how you structure the...

i am trying to find more information about charts and there doesn't seem to be any. i searched the web and B&N. if anybody knows how i can learn more about Charts in Acccess (Not excel) i would greatly appreciate it. my problem: i have tried to link the chart (parent/child) by clicking on...

Hi I just was did a search on the posts i did on this site and came across this post. i see that you are troubled with this type of report. i would like to help if i am able to. first post your questions. second, i used a combination of code. my report works fine. you can look at the microsoft...

hi as bat17 wrote, the important thing to remember is that validation is at the entry point. one of the biggest mistakes i made in the begining is that validation is achieved on table settings. now i find that the only restrictions i have on tables is type. i don't use any more lists on tables...