Search results

Wow, that was a creative workaround and did the job perfectly. Thanks a lot. SWK

I am trying to suppress the page numbering on the first page of the report. The first two pages both come from the report header section of the main report. On the first page there is some static text. Than comes the second page still in the report header which is a subreport. The third page...

Could somebody point me to some online resources about record level validation in Access. Thanks. SWK

Sorry, I didn't explain my case fully. I have a ValidationRule and a CurrentValue. I must run ValidationRule on CurrentValue and that should return true or false. I think I could justify why this validation is done in this way instead of the usual way, but that would be a longer story. I tried...

Could somebody help me with the Eval function? I have a string that I store in a variable. I would like this string to be evaluated to true or false, but I always get an error message so now I am totally lost how Eval function might work. TestValue="ReportRequest" When I write: ...

Could somebody tell me what is the code in Access to force Outlook to Send/Receive mails (as if I pushed the Send/Receive button on Outlook). I already have my mail in the Outbox folder but I couldn't find this code anywhere. Thanks for the help. SWK

Could somebody explain to me what is this thing with ADO and DAO? I am absolutely ignorant in this. I got as far that I know that if I checked the tickbox in the Tools/References section for DAO I can use things like this: Dim db As DAO.Database Dim QD As QueryDef whereas if it is unticked it...

Yes, now that I know how to do it, it is nice and smooth. For the time being I decided to use the SourceObject way instead of switching visible on-off, I felt that it is easier to keep some order on my form and I the change is instant this way too. Thanks guys for the help. SWK

Thanks Alexandre, In the meantime I found the following solution with SourceObject: Me.Content_ChooseFrom.SourceObject = "Content_ChooseIntQ" but you are probably right and I will experiment with Visible. Thanks again. SWK

I have an unbound subform on a form. On the main form I have an option button and I would need to change which subform to display as the option button changes. (no, I can't just modify the recordsource of the subform because the layout needs to change slightly as well) Could somebody show me...

Thanks Emohawk, SWK

Hi, I am trying to read a value from code, but the field name would need to come from a variable. I don't seem to be able to find a way to have the variable (FieldName in this case) evaluated before it is executed. I am sure it is easy once you know how to do it... Set rs =...

Thanks Rich, that was it. SWK

Yes, that was what I thought I would do if the selection method failed. Selecting would be nicer though because I could do it from record X to Y and that could be 30 records with very little in common (they must be next to each other but its sorted by a hidden value, so there is no obvious...

I haven't tried that yet, but I think this code would try to copy the selected records as a whole whereas I only need to insert the IDs of the selected records into a different table. I am doing it one at a time now using an append query filtered with the current record of the form using the...

Hi David, thanks for the reply. Either vb or an action query would be good for me. I select the records by holding down the shift key and moving down with the arrow key or clicking on a record selector (this is a continuous form). This blackens a number of record selectors - this is what I...

Hi there, I have been looking for some way to loop through the selected records of a continuous form. (I know it is easier with multiselect listbox but I didn't find a way to wrap the text there, which I need, since the display text is long and formatted.) Could somebody help me with this one...

Hi all, I would need to connect to a socket server from Access to pass it some data for processing and than writing the result back to the database. Does anybody have some example script that I could use? Or could you point me to a site where I could find such? Many thanks. SWK

Many thanks Jack, it did solve my problem. SWK

Hi all, I have been struggling for quite some time now with creating a query that would only return the records with the top N values where N is a user supplied parameter. I know I can use the Select Top 5 ... syntax but I have been unable to find a way that would enable users to enter the 5 as...