Search results

I've never been to happy with the way Access security works, so I recently wrote my own. I configured the startup to immediatly open a login form which looks to a binary file on the hard disk. The name of the binary file is ever changing in location and name. The contents of the binary file...

dhoffman, In reports, is there a difference between the chr() function and the chr$() function? Keagan Quilty Kilbride, Newfoundland

Please forgive me if this has been brought up before, but I ran the search on the main page, and I didn't get any results. Here's the problem. I've generated a couple of reports, as well as designing a few of my own. On one of my tables, I have a field names "Quit". If I put this field in the...

When those two Textboxes are automatically filled in, is the information in them also stored someplace? If they are, then the solution is simple. Don't store the data. Keagan Quilty Kilbride, Newfoundland

Ok. That worked. Thank you very much.

Could you please explain a bit better how to use that? Keagan Quilty Kilbride, Newfoundland

To get the ComboBox Empty, use this syntax. ComboBoxName.rowsource = "" This makes for a pretty useless combobox however. I use comboboxes in my tables all the time. The best way to change the values listed in them is to change the Rowsource property of the combobox. i.e...

I have a form that is filtered by the docmd so that it only shows certain records according to date. This is the command I have used DoCmd.OpenForm "frmFollowUp", acNormal, , "(datepart('q',[startdate]) = " & grpQuarter & " AND datepart('yyyy',[startdate]) = " & txtYear & ") OR...

No. That's not the problem I'm having. In VBA Code, you can do this. Dim strWhere as string Dim strFormName as string strWhere = "Category = '" & cboCategories & "'" strFormName = "frmPollingData" Docmd.OpenForm strFormName,acFormDS,,strWhere What I do now is this. Select Case grpScope...

On my Main Form I have an option group that determines which of three subforms are displayed. I am currently changing the SourceObject property of the subform window to display them. All three subforms have a "Category" field, and I was wondering if there is any way of applying a filter to the...

One solution is to remove the column heads and put actual buttons just above the list box. In the row source of the list box, you can add SQL code to change the listing order when the buttons are clicked. Keagan Quilty Kilbride, Newfoundland