Search results

I'm liking the Split() function. I can see how that would help. So I could run through the array using Instr to find an instance of Event etc. e.g. If $mystring contains "Event" then put in Event field. If $mystring contains "Date" then put in Date field. That kind of thing. I am not sure...

I want to create a routine that looks at a text file and parses the contents into fields in a database. It is based on the PGN chess file format. There would be an Event field, Date field etc. and of course the Moves field. Sample data: It could also look like this: Any suggestions on how...

Well understood Bob! My hands are tied! :)

I work for a company linked to corruption removal! Or more accurately, I work for Access World. :) They used their proprietary system, which all I know is more powerful than using Compact and Repair (which incidentally didn't remove the corruption).

Yup, you were right Bob. Corrupted. I uncorrupted it! Thanks for your diagnosis!

Great recommendations. Thank you!

Already tried it. I get the same error when trying to import. I get the first error and then No current record.

I am getting a rather strange error in one of my reports in Access 2007. If I edit the report, click the cross to close, click Yes to save, nothing happens - it is still open. If I close and reopen, the changes are missing. Now if I copy and paste this Report, I get this error: Name conflicts...

I have a form with a command button that runs a couple of update queries. But before these queries are run, I would like to save the current record. These queries will be using the data the current record and so it needs saving. How do I save the record programmatically? Thanks, Dave

I did the invisible button thing. Believe it or not I used to know this stuff but if you don't use it you lose it! I put Visible to No but that disables it. Thanks for the recommendation Bob.

Actually Bob, is there a line of code that lets me select the current record when I click on the label?

Clever idea Bob, thanks!

Bob, good suggestion to use Debug.Print. This helped me discover that the issue lays with where the cursor is. When I clicked the Label on another record, the cursor was still in the first record. Consequently, it picked up the values from the first record. Is that because I used a label or...

I have a continuous Form and a label field to the right of the last field. When I click this label, I want it to run some code to trigger a msgbox. My code is below. Dim txtAdvice As String txtAdvice = "" If (Me.field1= "abc") And (Me.field2= "No") Then txtAdvice =...

How can I have a list of my Outlook emails in a Form? Can I somehow embed an Outlook email list control or something? Thanks, Dave

Got it now. Stupid me. Two lines of code! lol Thanks for your help.

Did you mean this? i.e. is there supposed to be a comma after acNormal? DoCmd.OpenForm "Contact List", acNormal, Forms![Contact List].RecordSource = "qry1"

Each query is very different. They are very complex queries. Some of those queries are about 3 queries deep!

So could I do this instead? DoCmd.OpenForm "Contact List", acNormal,"qry1" And then just have a different query for each button?

Yes, the form is still open. Client wants it that way. But I've also got the same code in the GotFocus event. I thought if I switched to it, then because it has GotFocus it would then run the code changing the record source. Or is it too late then?