Search results

Maybe the top 5 are already included in the CLINIC-NEW? Try UNION ALL Also try putting brackets around the two UNIONed queries (select blah blah) UNION ALL (select blah blah);

If CheckDate = Date() then Fieldname.Visible = True else Fieldname.Visible = false end if

You might be able to open the other file directly (using DAO/Jet) and change the tabledefs. I'm not sure on the details, but it gives you somewhere to start looking...

Have a look at "Microsoft Date and Time Picker Control". I'm not sure if it comes standard with Access or is part of another MS package. By default, it gives you a dropdown calendar to select a date, but if you change its options, you can have a custom date & time format, with up/down arrows...

A possible alternative... Set up copies of the report in both portrait & landscape, then open the required one based on the user's selection on the form.

0#/0#\ 0#:00\ >L?!;0;_ # is an optional number or whitespace (whitespaces removed after entry) ? is an optional letter L is a required letter 0 is a required number This lets them be extra lazy & just type "1/1 1:00 A", rather than "01/01 01:00 AM" In fact you could replace the L with...

Strange... worked for me the way it was :confused: Maybe it's acting differently because it was in the Close event (I just tested it as a Button.OnClick) or different version of Access (I'm using 2003)

Yak's milk is pink

Lord save us from so-called Managers! :eek:

Generally, I guess so... that way if a drive isn't mapped (or is mapped differently) it will still work. Yes, that's what I was thinking :)

You can't have a report based on more than one query (as far as I know). You can have running totals or section totals on a report.

Banana, Here's my suggestion... At the remote sites, put the back-end in the same mapped drive eg, at Location 1, have a network mapped drive Z: that points to Server1\SharedFolder at Location 2, have a network mapped drive Z: that points to Server2\SharedFolder at Location 3, have a network...

Put the code in the DataTypes textbox's After Update, On Exit, or On Lost Focus event. Also a SELECT CASE statement would be better than multiple IF's eg Data1.Enabled = False Data2.Enabled = False ...etc etc... Select Case DataTypes Case 1 Data1.Enabled Case 2 ...etc...

Try this: DoCmd.OpenReport "reportname", acViewPreview, , , acWindowNormal (Note the extra commas.) If that doesn't work, try: DoCmd.OpenReport "reportname", acViewPreview, , , acDialog acDialog makes it open Popup and Modal.

Access help files? (oh wait, you said handy/quick...) :p

Let's see if I have this straight. You have 2 ASP pages. The first takes input and manually constructs a URL to the second, including querystring parameters. I think you'll have to either replace it with a POST form, or (if you're using ASP.NET) do some more complicated stuff to read the...

# is Access's date delimiter. Kind of like putting something in quotes forces it to be evaluated as a string. Not unique to reports, but unique to Access. I think it's also used in MS SQL? Though SQL is smarter about converting strings to dates (from memory...) I know what you mean about...

Are you talking about table structure? Or form/report design? Since we're in the query forum, maybe you're talking about queries...? OK... In queries you don't ignore duplicates, you keep them in. You deal with them when you're using the data (in form, report, or whatever). In forms, you...

You want the DateDiff function... DateDiff(interval, date1, date2[, firstdayofweek[, firstweekofyear]]) So, to find how many days a case was open... DateDiff("d", [dateopen], [dateclosed]) Closed on the same day = 0 Closed the next day = 1 etc or if you want hours, DateDiff("h", [dateopen]...

Dim ctrl As Control For Each ctrl In Me.Controls If ctrl.ControlType = acCheckBox Then ctrl.Value = False End If Next