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...

Thanks, #2 helped me work it out. I hadn't thought of adding a new column that would mark the original order.

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...

TheAceMan1, yes, it works as desired if I switch the tab order and code it to go to one control previous in the order. Kind of ugly though and throws off the flow for people who click into a field. A google search brought up this: http://support.microsoft.com/kb/327821 Not sure if it applies...

Remou, I'm not really sure what this is supposed to do. Tab is coming up as KeyCode=9 for me. I tried substituting that in the cases, but that basically prevents the cursor from moving. Also, I want to move between recordsets, ie from the end of one subform to the beginning of the next, or some...

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...

Works - thanks!!

Remou, yes I go in using shift. Initially it's ok, but if I go into datasheet view to test and then back into design view, that's when the welcome page pops up. Please elaborate on global design variable - I'm not very advanced. Thanks.

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...

DrGreg1408, it is a combobox, but my problem is not that the check is not working, but that the event fires too often (ie, when moving between parent and child records rather than just when leaving the parent record).

Possibly, but I didn't really want to get rid of the navigation buttons at the bottom - people are used to those for scrolling back and forth, sorting on some field and then going to first or last record, etc. The form is used for ongoing edits (during which time they might accidentally blank...

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...

Thanks, that works!

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...

Thank you AceMan1 - worked like a charm! :-)

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.