Search results for query: *

Hello, I may not know exactly what words to search for, so I apologize if this question has already been addressed in other threads. I want to run some preliminary checks on data that is sent to me in excel form, just checking columns for appropriate variable length and character/numeric...

Hi, I am outputting the results of proc tabulate to a series of sheets in an excel workbook. The problem is that each proc tabulate depends on a "where" statement. If the result of the "where" yields no records, I still want it to output to excel with null values. Right now the log just says...

Hi, this probably is relatively simple, but I can't figure it out. I have a spreadsheet with many columns that I need to sort based on a unique numeric 'keycode', but the sort has to be in the same order as the 'keycode' in another spreadsheet, which is neither ascending or descending. I have...

Hello, Is it necessary to first write data to a worksheet in order to create a chart for it? I have a model that reads data from a text file and would like to create the chart in vba without first outputting the data to a worksheet. Is this possible? Thanks for any help.

Hello, I have a main form for physician practices that contains a subform of individual physicians in the practice. This subform contains, among other items, tax id numbers. It seems the tax numbers can change so I need to add effective dates and allow multiple tax numbers per physician. I'm...

Hello, I am trying to use key down (If KeyCode=vbKeyTab) to control the flow from one control to another on a form with subforms on a tab control. I initially used the LostFocus event, but this drives people crazy if they use the mouse to navigate rather than tab (they click into a field but...

Hello, I have a welcome page for people doing data entry, with the rest of the database hidden. This welcome page pops back up when the user closes the form, and the user exits the database through a button click on this page. Is there any way to stop this page from popping up when I myself...

Hello, I have a bound form with bound subforms on tabbed pages. I have a field on the main parent form "Application_Status" that I want to check for null, but only before leaving the record. My initial attempt was to use the form's BeforeUpdate event, but this causes it to run (and pop up my...

Hello, This is very far from my area of expertise, but has anyone here had problems with their multi-user database split over a unix network? I haven't had any problems so far in testing phase, but am wondering if more problems are likely if we add 3 users over the current 3. Our IT person...

Hello, I have a parent form with a control tab with multiple pages, a different subform on each page. I am using the lostfocus event on the last control on each page to have the cursor move to the first control on the next page using docmd.gotocontrol. This works ok, but: The user would like...

Hello, I am forcing upper case for all fields on my form using the form's key press event. For a field containing email address, I want to turn this off and allow whatever case. Does anyone have code for this? Thanks for your help.

Hello, I have a subform that is disabled unless a field value is set to "yes". The caption above the subform is greyed out until the subform is enabled, but the appearance of the actual subform is the same whether or not it is enabled. Is it possible to grey out the subform when it is not...

Hello, I have a form that has primary and secondary contact information, and a subform to track phone calls. I want to populate a combo box list (not limited to list) for "PersonContacted" with the names of the primary and secondary contact names. I've tried to set the row source for the combo...

Hello, I would like to output summary stats like min, max, avg for field values after I read in a text file (I'm working in excel vba). I thought this would be simple, but I'm having trouble figuring it out - there don't seem to be any predefined functions for these procedures. Do the min and...

Hello, I think this is a simple question (I'm not an advanced user). I would like to number weeks relative to ending Friday - ie, April 26, 2008 through May 2, 2008 would be counted in the same week. The formula I tried was: WeekNumber=DateDiff("w",StartDate,X_date,vbSaturday) but this still...

Hi, I'm sure this has already been covered somewhere, but the search functionality on the site is not up, so, sorry! The .ldb file for my backend is not deleting, even after everyone has exited. When I try a compact and repair it says *I* am still in it, which I know is not the case. Does...

Hi, I have a strange situation: Our database has several tables with one to many relationship. We have been doing data entry with multiple users and have been commiting the backend every couple days using Tortoise SVN versioning software. Occasionally we have had errors and have had to go in...

Is there an easy way (ie, not too much coding) to do a mail merge from a database with a one-to-many relationship? We have a Word form letter that, for each record, we want to list at the bottom the linked child records. It seems we have to array all the child records into a single record in...

Hi, I have a front end form with 2 child subforms. Multiple people are performing data entry or running queries against the backend. I had no record locks and inevitably we ran into problems. (This is not really my regular job - just an application I have had to develop for a specific...

Hi all, Is there any way to make a drop down list refer to the tables in the access db? The purpose is to automate an update query: the user needs to regularly update the db with info from a table that is imported into access weekly. I would like to allow the user to select the table he has...