Search results

On the Field line, at the top of Query Design View. Ever seen it name a column "Expr1"? That's an alias. http://office.microsoft.com/en-us/training/show-or-hide-your-fields-RZ010359157.aspx?section=6

If you can take your system down/out of service for about five minutes you can fix this. Split the field into two fields - ReportYear and ReportNumber. Combine them in a query for display, though you'll have to change your forms a bit if your users really are manually entering the number...

It's an easy one to miss - I only know it because I've scratched my head over it about 87 times!

Stupid question first: Are you looking at it in Print Preview mode? OnFormat never fires in regular 'Report View' mode.

Why? Saved queries are more efficient and generally easier to debug.

You're just trolling now, right? There was no 'Europe' in the Stone Age. Even if it WERE true that there were people here before the Native Americans (who likely crossed in from Siberia), that's nothing like what we did several hundred years ago through lies, backstabbing, and violence.

...no one said anything about Printers?? In your Form Design View, click the box in the Top Left. Then go to Properties > Data. Does it have a Record Source? Now click the field you're worried about. Properties > Data. Does it have a Record Source?

Actually this is not true. It's not bleedthrough from the window behind it or even the desktop beneath it, but it DOES change in some bizarre way when I move the form around. Almost like watching the "Magnifying glass" screensaver, but very small, and always in an orange/grey color scheme, even...

I keep seeing this in a handful of forms... Access 2010. Some are converted, some are newly made. No pattern I can discern... anybody else seen this or know how to avoid it? It always seems to be the same color pattern, so it's not transparency bleedthrough. Obviously it only happens on Windowed...

In Word 2010, go to Mailings > Start Mail Merge > Mail Merge Wizard. It may be a different navigation in other versions, but it's similar. In Step 3, select Edit Recipient List on the right edge. What is the Data Source listed in the bottom left? Does it match your Access database? Is the field...

I think you need to go into it from the Word side and add the field to your letter. Make sure of course that whatever data source from Access that Word is using (not sure it can even use queries, but worth asking) includes the field!

That is a lot of version upgrades at once. What, exactly, isn't working? What error message, if any, are you getting?

I like AJ's idea of snapping it to the nearest/next...

Well, is that the filepath? Are you on the same machine where that C:\ is?

Your edit is cracking me up. :p

No, look at the end of your first line,. There's no space after Betaald.

Any specific part can be replaced. HDD are not permanent either.

I was too busy trying to figure out where Merseyside was... dumb Yank here.

Do you absolutely HAVE to store the "Inc #" part in the field itself? Because what I would do, for sanity's sake, is: Strip all the existing records down to the "4526" level. Change your field LABEL to Inc # Add a calculated field to your query: IncidentNumber: "Inc # " & [IncNum] Maybe put an...

That's true, since these aren't real Date/Time fields it won't care if you write it as 89:33 for a while. Alternatively you can rewrite step 1 and step 3 to parse it for hours as well... the logic is similar.