Search results for query: *

I have a univarchar column which cannot be indexed due to the length of the field. On my dev database, I can apply the index if I change the column to be a varchar. Does anybody know if it is possible to convert a univarchar field to a varchar one on a production database without losing the...

I recently converted my database from 97 to XP (not horrendous, but not as straightforward as it should have been.) I had been using several msgboxes which had bolded titles, using syntax like: MsgBox "hi " & Constants.NL & " @this is the body@ " These don't work in XP; the @ signs show up...

Hello, I'm using Access XP. When trying to compile an MDE and failing, it gives a really uninformative error message ("Could not make MDE file") with no option to see details. As I remember, Access 97 pinpointed at least the module or form which was giving problems; right now my "solution" is to...

Hello, the following code (written in a macro language which can call out to the win32 API) switches from the user's window to an Access window ("tracking"), and activates a form with the "f5" key. In theory. It all works apart from the "f5" key, which doesn't seem to be accepted by the Access...

Hello, I had a vba script which switched windows between two applications. The code below used to work in Windows 95, but doesn't in Windows XP. I determined using the debugger that it is the closewindow statement which doesn't work. Any idea what's going on here? Thanks dim ntsid as long dim...

Hello, the company I work for is moving to an XP platform; the database I maintain won't work using Access 97 under the XP installation without the VB6 runtime, which the company is reluctant to include as part of the base rollout. So, I'm having to convert it into Access XP. The built in...

I'm baffled by a bug which is happening; I have a report which is invoked by two different options on a form: Case 3 If IsDate(Nz(Text21.value)) Then DoCmd.OpenReport "detailed-summaryofevents", acViewPreview, , "thedate =#" _ &...

Hello, I have the following tables: book: book_number ... book_event: book_number --> book.book_number event timestamp I devised a form which shows you the number of books which move from {one set of events} to {another set of events} within a specified interval, between a certain set of...

Hello, I'd like to be able to save today's date in an excel worksheet, preferably using a cell formula. To be clear, when I open the spreadsheet tomorrow, it should still have today's date (the date that I saved it) in the cell. Thanks

Hello, I'm trying to print a form which is too wide to fit on a portrait orientation printout. I'm using the code: DoCmd.PrintOut Is there any way to modify this so that it prints in landscape? Thanks!

Say I have the function in a module: private function getWords() as Variant dim words as String(10) ... getWords = words end function Now say that I need to use the array in a ListResults function in a form; how would you best accomplish this? I can't assign the getWords results to an...

I have a boolean field coming into a report; I would like to change the title of a section based on the field. I currently do this by "displaying" the field, but setting visibility to false; then I have two fields which each of the alternate titles. In the report_activated event procedure, I...

I have the following tables (abbreviated): User ---- username firstname lastname role_code - describes the role of the user Book_Event ---------- book_number user timestamp event_code - describes the event I wrote the following query to provide me with a list of users (within specific roles)...

I am getting the following error: Runtime Error 2055 The expression '|' you entered is invalid The code in question is attempting to msgbox a text field on a report, in the report_activate event procedure. The code works when the report is opened from the database window, but not when it is...

Hi, I choose to give my users a msgbox rather than a blank report when there is no data. On all but one of my reports, adding the following (or similar) to the report's events works fine. However, on the one particular report, this following is not triggered, and the report shows up with no...

I used the reports wizard to generate a report from a query. The generated report includes a footer stating "Page x of y"; unfortunately, for some reason, this is too wide for the preview, so every second page contains the extreme right of the footer ("of y") and nothing else. That isn't the...

I maintain a "development" version of a "production" database. Every time I release it I first delete all of the tables in development, import the tables from production (with current data), build an MDE file, and move it to the production location. I'm working on automating at least the first...

Hello, I have a table as follows: User Item Event Timestamp Due to a coding error, the table has several hundred duplicate rows, as follows: User / Item / Event / Timestamp Joe / 1 / A / 5/26/4 12:34 Peter / 1 / A / 5/26/4 12:45 Janice / 4 / B / 5/27/4 8:19 Sherry / 4 / B / 5/27/4 8:26...

Hello, I'm working with a self-taught programmer on a project, and her coding style is driving me nuts. I attempted to suggest that we adopt a standard, but she vehemently defended her style, saying it was "personal choice" and "made most sense to her". Here's some of her code snippets; what...

Hello, I have a form which lays out a series of address labels for printing. When the user is ready to print, they press a button, and application deals with the printing for them. Since my users are Lusers, I would like to (as part of the print process) either a) set the print margins for them...