Search results

A slightly simpler version of the above is: Fieldname.Visible = CheckDate = Date() In this version, if Date = CheckDate, then Fieldname will be visible, otherwise invisible. Good luck.

If I'm understanding you correctly, you simply need to add an 'or' criteria entry. In design view of your query, add another entry in the box below the criteria box (it says 'or' over there on the left). It should say 'Is Null" After that your query will bring up any null entries, and any...

Problem Solved, I think. The method you're using should work fine. You simply need to check the spelling of the word 'Transparent.' Good luk. -Curt

OK, this is a bit of a brute-force solution which does not answer the question of why your form is behaving as it is, but it should make it work. In the On Open event for the form, call the code that's normally called when the ALL EMPLOYEES button is clicked. It should do the same thing as...

There is another way! One way I use which allows a main form to remain full size onscreen when another smaller (not-maximized) form is called up, is to make the small form a pop-up form. (See Form Properties/Other). You may or may not want to make it modal as well. Look them up in HELP to...

Thanks for the starter. It took some figgerin, but here's the (pretty simple) code I came up with, which returns the name of the source database for the table called "Cues." Public Function FindSource(dbname As String) Dim dbs As Database, tdf As TableDef Set dbs = CurrentDb Set...

I'm working with a split database. I frequently change the b/e link to different .mdb files. Sometimes it's because I'm debugging or testing changes to the front end, sometimes it's because I'm working with data from different projects. I thought it would be nice if I could display the name...

I haven't time just at the moment to reply, but I can look this up this week-end and see if I can figure out what this was about - it was posted 5 years ago, I didn't ever receive a reply, so I worked out SOMETHING to do what I was doing. -Curt

ONE of the many ways to deal with this is to create your form differently. Put what you now have in your header on a main form. Put everything else on a subform on that main form. This way, your header information will always be visible, and everything else can be scrolled within the...

Greetings, all. I have two combo-boxes in the header of a form. The form appears as a window (Not full screen). The values of the combo-boxes are set on open, but when the form opens, they appear to be blank. But they only appear blank. If I click on one, it's value appears. If I move...

Would they still have to have Access installed as the end user? That is what edtab is referring to when he says you could make a run-time version of your database with the Developer's Edition. You can compile a database application which will include everything needed to make it run without...

Thanks for the information. I feel better already. -Curt

Yes but... I don't really plan to have two version of Access co-existing. I only would like to know if A97 and WinXP can play well together.

I am about to upgrade to a new computer, and therefore a new operating system. Question is, will Access97 run OK on Windows XP Professional. Is there anything I must look out for. I'm hoping to not have to change to Access2002 right now, as I'm about to begin a big new project which requires...

I don't know the answer to the question about implementing this in your form. I tried to do the same sort of thing and couldn't get it to work. However, for your reports, you can replace your If / Then / Else statement to the following, which gives the same results:[Cancelled Line].Visible =...

You're supposed to be able to do that with AutoFormat. Make a form with the styles, etc. that you want, then select Format/AutoFormat, then click on Customize, and you're supposed to be able to create a template which may be applied to everything. I haven't used it myself, so check out the...

Here's how I've done it with success:'Your code executes first DoCmd.OpenReport "ReportName", acViewPreview Do While Application.CurrentObjectName = "ReportName" DoEvents 'Yield to other processes. Loop 'The rest of the code follows hereThis opens the report in Preview, lets the user...

The combo-box to which I was referring is the one at the top of the Access print-preview page, which has a list of choices for zoom size. The standard zoom sizes of 200, 150, 100, 75, 50, 25, 10 and Fit, are the only ones which I know how to call with the above code. I, too, would like to know...

You probably already know this, but in case you don't... You can use the following to open a report in one of the zoom sizes which are in the combo-box, but I don't know how you'd specify a choice which would normally have to be typed into that box. This example would open a report at...

You're right, I was asking a question, and the code was irrelevant to that one. I'll make a disclaimer first that I think this is kind of crude programming, and feels rather brute-force, but it does work. Maybe someone else will have some sweet refinements... This code is called from a form...