Search results

Adam, The Page Setup for reports is independent for each report, meaning the settings in File -> Page Setup in Report A are different than they are for Report B. Have you looked in there? Additionally, a switchboard? I'm against them as they write a ton of extraneous code "for you" (to clean...

PivotCharts (and PivotTables) are perfectly viable in both applications, just not this particular situation (as far as I can tell). I think he's just trying to show a graph of who has done X amount of training, in which case, and especially in Access, a query is a way to go, with a chart based...

Wow, you can always tell the Excel users that think Access is "advanced Excel". A Pivotchart? Really? What is it you're trying to do in English terms, not Excel terms? You're getting the ID numbers associated with the employee names. Did you import the names from Excel and then have Access...

That' nice. Is there a question? (Post your SQL statement, and anything else problem-related.)

Look for Filemaker drivers for Access on Google. Filemaker is a popular DB used on Macs. If you're not using that, you could use all CSV file links as tables (store your Access tables as CSVs, or comma separated values, which are just text files with the data in them), and both a PC and a Mac...

You can automatically send email like this (put it in a "Send Email" button or the AfterUpdate event of a field): DoCmd.SendObject acSendNoObject, , , MailDistribList, , , MailSubject, MailMessage, False MailDistribList can be one or more email addresses. Separate multiples with a semi-colon...

You definitely need the # marks. Make it this: .FindFirst ("[workdate] = #" & Date & "#") And Paul, was there a sale on Boone's Farm? ;) (I'm a six pack in myself... lol...)

Well, this really has nothing to do with VBA and it's not asked in the right place, but there really isn't a right place for this as it's either video driver related or a simple fix. Let's go simple first. Is the code window not maximized but rather restored? In other words, can you click the...

In a report, each report has a separate "page setup" that's stored with the report. Go to the report, open it in design mode, and then select File -> Page Setup in the drop-down menus. From there, click on the Columns tab, enter the number of columns you want, and then select "Across then...

Excuse the ignorance again, but are we talking a one-to-one relationship as to the number of characters per number here? For example, is there one character in Arabic that is the equivalent of the number "1" in English, one character for "2", etc.? If it's more than one character, then you'll...

If you can still get to the Immediate Window for code (press Ctrl-G), then you can type this in to perhaps get everything back to normal: CurrentDb.Properties("AllowFullMenus") = True CurrentDb.Properties("AllowShortcutMenus") = True CurrentDb.Properties("AllowBuiltInToolbars") = True (You can...

This is because you cannot mix the two languages like that. You could fake it by changing the font from Western (English) to Arabic, just on those fields. Also, excuse my ignorance, but if the numbers read right to left, that may pose a problem as well. I really don't know if they do or...

Just to make sure it's good and confusing, Access 2007 dumps Workgroup Security altogether (no MDW file support at all). Really, though, don't make a mountain out of a molehill. We're talking about Allow/Deny privileges in Access here, which are easy to set up and maintain. (Ten years doing...

Post what you are doing as that's pretty ambiguous.

Also, using CurrentDb.Execute will skip the messages without having to SetWarnings off and on.

For anyone curious, I'm 95% of the way there. This will handle nearly all situations and sort the field names for you, and it even gives you a few options. It's not optimized and there are a few things it won't do, but it handles field names, field types, field sizes, indexes, and primary...

A few things off the top of my head: 1) Check Accessibility Options in Control Panel and make sure you have Sticky Keys, Filter Keys, and Toggle Keys disabled. These little annoyances are defaulted to be on and they will cause all sorts of weirdness. 2) Did you try completely closing out of...

So, in essence, the weirdest part right now is having to email it to yourself? Can you try copying it to a USB Key? Also, have you attempted to completely reset the document variable (Set doc = Nothing) and then redefine it so that we know there are not hidden characters in there? I know...

For anyone else looking, it this he's referring to: Connection:= _ "Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=" & CurrentProject.FullName & ";Mode=Read;Extended Properties="""";Jet OLEDB:System database="""";Jet OLEDB:Registry Path="""";Jet OLEDB:Engine Type=6;Jet...

I know how to program it; instead, I'm trying to make sure that it doesn't already exist so that I don't rewrite what someone already has. A Google search comes up empty for the most part (someone had written a custom add-in of all things), and it's not horribly difficult to write, just a...