Replies

I’ve notice that also, but it is not consistent. I’m thinking it may having something to do with which mode it was in the last time it was saved.

Your original post said this:

(1) Make a query to generate a list that has one row for each attribute within each memo field, like this.

Item1, Back, Red
Item1, Front, Green
Item2, Back, Blue
Item2, Front, Green
Item3, Back, Green
Item4, Front, Blue
Item4, Front, Red

Well, that’s exactly what my query does! So what is the misunderstanding?

I just looked back at the original post, and there was apparently a leading space before each color. So yes, my WHERE clause would have to be adjusted accordingly. All of which assumes, of course, that the real data is consistent!

David,
Thanks for the compliment, and you made a valid point about a skill also being a substring of another skill. However, I think that can be handled. Here is my original SQL and a revised version (and we are back to talking about colours):

SELECT Item, “Back” AS Position, Colour FROM tblItems, tblColours WHERE Back LIKE “*” & Colour & “*”
UNION SELECT Item, “Front”, Colour FROM tblItems, tblColours WHERE Front LIKE “*” & Colour & “*”

SELECT Item, “Back” AS Position, Colour FROM tblItems, tblColours WHERE “;” & Back & “;” LIKE “*;” & Colour & “;*”
UNION SELECT Item, “Front”, Colour FROM tblItems, tblColours WHERE “;” & Front & “;” LIKE “*;” & Colour & “;*”

What this does is put a semi-colon in front of the string being searched, then also putting it around the Colour. So when searching for the Colour “Red”, the query looks for “;Red;” such that it would not find a match in “;Light Red;”.

I think query #1 can be done with this (you could even modify it to append the records to a table for further manipulation):

SELECT Item, “Back” AS Position, Colour FROM tblItems, tblColours WHERE Back LIKE “*” & Colour & “*”
UNION SELECT Item, “Front”, Colour FROM tblItems, tblColours WHERE Front LIKE “*” & Colour & “*”

There is a trigger, it is called the Current event.

I also have no idea why its there! Don’t know when or where I got the code from, I just copy it from project to project. It works so I don’t question it!:)

Glad it solved your problem.

I used this instead of the .To, and it works just fine:
Set objOutlook = CreateObject(“Outlook.Application”)

Set objOutlookMsg = objOutlook.CreateItem(0)
With objOutlookMsg
Set objOutlookRecip = .Recipients.Add(rs!EmailAddress)
objOutlookRecip.Type = 1
.Subject = strSubject
‘ etc,

Check your references. You are likely to find one “Missing”.

Here’s how I do it. I keep a table with the SQL for each query. In the Where clause of each SQL, I stick something like “AND 0=0”. For example, your query would have this:

WHERE (((t_survey.survey_date) Is Null) AND ((t_survey.report_completed_date) Is Null)) AND 1=1

Prior to calling the report, I use the Replace function to replace “1=1” with whatever I want (like “Surveyor=12345”) and then replace the SQL in the query behind the report. In your case, I’d cycle through the Surveyor table and run the report for each Surveyor. This way, you can use the Output to PDF functionality within Access.

Or, there is this. Let’s suppose your fieldname is “MonthName”. You could sort by this expression:

Month( [MonthName] & ” 1″)

I don’t know what you mean by a “Windows Database Server” either. I’m guessing they don’t understand how Access works. There are 2 separate issues here, where you put the Access backend database, and how users connect. You can put the database itself on any server because it is just being a file server for the Access database. I had a client that had it sitting on a Linux server. You will need a Windows Server to host Terminal Services (or Citrix) so you’d be remoting into a Windows box to run Access. Your file server and host machine could be the same. Doesn’t matter.

Personally, I would have the database on a server, and then use Remote DeskTop from each of the remote users to log into that server. This way they would be “local” to the database. Each user would have separate directory, which would contain a copy of the frontend.

Basically the cursor has to be sitting in a text field that can accept the datastream from the card reader. You’d then then have to the format of the string to do anything with it.

If you populated 1RGC with just the codes you wanted, you don’t need a LEFT JOIN, you could have used an INNER JOIN. My suggested use of the LEFT JOIN assume you already had a table with ALL the codes in it, and you’d use the IN statement to select the ones you wanted.

You should be able to add the fields from tblInvoiceDetailTable to the query in Design View.