Search results

No. I was pulled off that project and had to work on something else. But I've just gone with two text boxes for them to enter the dates. That works ok.

This is some code that doesn't work (the call to open the form works fine) Private Sub Form_Open(Cancel As Integer) Dim dt As String dt = format(OpenArgs,"yyyy") Me.StDtSel.Year= dt dt = Format(OpenArgs, "m") Me.StDtSel.Month = dt dt = Format(OpenArgs, "d") Me.StDtSel.Day = dt...

I have ActiveX Calendar Control 10 in Access 2003 on a form that is called from another form that feeds in a date in OpenArgs. The date will NOT be today's date. I need to have the calendar set to that date. All threads dealing with setting the date seem to set it to today's date. How can I set...

I have a similar problem, but the sheets are all named with account numbers (not sequential). Is there any way to refer to the sheet by position? How about a For Each Sheet loop? How would that work (if it is possible to do that)?

How about if you create the TO string separately so that it only shows the contacts that are there?

Instead of toggling the background color, toggle the forcolor between what it normally is and the background color. (Of course, you've got to be sure that it always ends up as its normal color and not the background color.)

When I worked with AS400/RPG, we had a utility that copied all the "flower box" comments in the code and saved them as a text document. This was then printed up as documentation for the internal operation of the system to be used by an ID department. You could do something like this by following...

I've been in that situation twice. On both occasions, the conversion was a real bear. In both cases, someone in charge of the new data repository didn't think we needed certain fields so they weren't supplied. We had to ask for them. Sometimes we got them and sometimes they didn't think they...

To find exact duplicates in fields, you could create an aggregate query, grouping on the name field (or whatever the field in which you are looking for duplicates) and then doing a count on the same field. Set the criteria for > 1 in the count field. This will give you a list of all entries that...

You could loop through the fields collection of the criteria input form and create a WHERE clause to include any input data and ignore any fields not containing anything. Then tack this onto the SQL statement for the query and set the query's SQL property to the SQL statement you just constructed.

I'm not exactly sure which icon you are talking about. The icon that appears on the desktop can be set on the Tools>Startup dialog box.

OK, here goes nothing. First of all, check Help for rnd() Then check Help for info about modifying a query during runtime (actually, it's just a matter of changing the query's SQL at runtime. Create a Select Distinct query that selects only the category field from the table in which the...

On the other hand, if it is not a look up table, the applicant's status for the job should be part of the table that join's the applicants table and the jobs table, since each record in that table represents one applicant's relation to one particular job. You should still have a lookup table...

Try SELECT DISTINCT Table1.ReportingPerson, Table1.Date, Table.WR04, Table2.Date, Table2.WR05, Table3.Date, Table3.WR06 FROM Table1 INNER JOIN Table2 ON Table1.ReportingPerson = Table2.ReportingPerson INNER JOIN Table3 ON Table2.ReportingPerson = Table3.ReportingPerson I think this will give...

It appears that the sp is the culprit. In the query containing the sp, I set the field coming from the sp to 0 and removed the sp. Report/sub-report combination now working fine.

OOps. When I open the sub-report by itself, it' fine. The sub-report is not linked to the main report. I just switched out the query for the old one which has only two tables and the report/sub-report combination works fine. The problem is that my job is to create queries so that those two...

I have a report that has a sub report in it. The report runs fine except the sub report doesn't show up at all. When the sub-report is run by itself. When I try to open the report I get a message that says: "You can't use a pas-through or non-fixed-column crosstab query as a record source for a...

What was the problem? Did you use the wizard?

It appears that all you need is a crosstab query.

Are you trying to create one front end db and four back end dbs and each department cannot see the records of the other?