Search results

Is it possible to create a table link that is read only. I realize that there a a number of work-arounds, but I'm curious about this functionality specifically.

I have a table with 140 fields (I know, this is too many). I have a date field that intermittently will not allow data to be entered. There is a pattern to the data it will not accept, but it seems to only occur in certain records and what it will or will not allow seems different in each...

I have an OutputTo command that works fine until I convert the database to and mde file, then I get Error 2046: The command or action 'OutputTo' isn't available now. Here's my code: DoCmd.OutputTo acOutputQuery, strQuery, acFormatXLS, strSaveFileName Any ideas why this would be happening?

Is there a maximum number of tables and/or queries that can be in a union query?

I have to create an ADO connection to a password protected backend. Not user-level security, but simple file security. How do I format the connection string to pass the password? The arguments that work for user-level security do not work.

Is there a Snapshot Viewer out there for Palm and/or Windows Mobile? Microsoft doesn't seem to have one.

I require tight control over the pagination of a report. As such, I cannot allow the controls to grow or shrink, but I do want to allow the users to add as much text to certain fields as possible. Is there a way to auto shrink text to fit in the space provided. I've written some code that...

I have a control that CanGrow. When it grows, I also need the caption to grow to the same height. Tried programmatically doing it, but the Format event fires before the control is grown, and the Print event is too late to resize labels. There appears to be nowhere to slip it in...

I need to keep a subreport together on one page if possible. The KeepTogether property in both the sub and main form are set to Yes, but this does nothing.

As the title suggests, I need to know how to ensure the label always stays on the same page as the first record of a control.

I'm using the Nz function to interrogate a date field in a query. Problem is that Access does not seem to recognize the returned value as a date when the original value was null. Here's what I've tried: NewDate: Nz([OldDate],0) and NewDate: Nz([OldDate],#01/01/1900#) I've also tried...

I'm running some code from the main form's OnOpen event that alters the record source of a subform. I requery the subform at the end of the subroutine, but the changes are not shown until I close and reopen the form. It appears that the requery is not working. Is there a trick to this? :confused:

I've heard IS gurus say that Access security is quite poor compared to other systems like SQL Server or Oracle. Just wondering how much truth there is to this and how much of a concern it should be. Are there any good online resources addressing this?

I'm having trouble opening an ADO recordset using a union SQL statement as the source. I'm wondering if it will even let you do that. I'm trying to avoid storing the union query in the database and calling it as the source if possible. Of note, I am attempting to open two recordsets with...

I have a form (actually a subform, but that's not relevant), displayed as a continuous form, that the user can use to edit the display order of certain records. The form displays the records and allows the user to move them up or down in the order by clicking an up or down arrow. In the...

When I run the following code I get an error (see attachment) at the last line. I've checked that all the table and field references are correct. Can anyone see a problem anywhere? (Note that GetBackendPath is a function that finds the path to the table, and it works fine. frmCurrent is a...

Does anyone how to manipulate the Show On Toolbar property of a menu or toolbar through code? I've used the CommandBar().Protection property to set the other properties, but there seems to be no constant for this property.

Anyone know where I can find a list of the numeric values associated with the permissions constants (Access 2000 - DAO 3.6 library)?

I'm guessing that this can't be done, but does anyone know of a way to display page tabs on multiple rows rather that in a single line?

I want to be able to place a hyperlink in a custom menu and change the path at runtime using VBA. How do I do this?