Search results

Grouping & Parameters Hope someone can correct me on what I’m doing wrong, I’ve tried 2 versions of the below query which always end in ODBC failures. Any help is appreciated. SELECT DistributorInput.DistributorNumber, DistributorInput.InputFileName, Count(DistributorInput.InputFileName) AS...

Importing text files Can someone point me to an adequate tutorial on importing text (CSV) files into access 97 via code? I haven’t found one yet that I am comfortable with.

Set import dialog box Is it possible through code to set the LOOK IN, FILE NAME, and FILES OF TYPE options in the import dialog box through code??

Modify text file I have never really used dao or recordsets in any of my coding experience but think I am about too. I’ve got my form to the point where I can determine whether a file exists in particular directory and I need to modify this file by opening it (thru code) going to the bottom of...

I’d like to set up a form with several buttons, earch with a distributor name on it & a number too. The number is a count of the shipping files each distributor has, waiting to be processed. These files sit at various places on our network directory, is there some way for me to tell access to...

Dlookup I’m fine tuning a report & am using the dlookup function in the detail sections onFormat event. I typed this code: intCollCod = DLookup("Code", "Collections", Title = Me.Title) but this isn’t executing correctly, intCollCod keeps returning the value of the first collection in the...

List box entries written to email How might I click on several list box entries & have them be written to the body of an email?

I was wondering could I use an array as the CASE in a CASE STATEMENT like below? Select case array(I,J) Case (1,1) Case (1,2) End select

# sign added to end of value When I type: tempSAP = 60614907704 I get this instead: tempSAP = 60614907704# Could someone explain please?

Missing menu I cannot find nor enable a custom menu that I have no recollection of ever having deleted or disabled in my system. This is scary. Any suggestions?

Printer icon face id value Can someone please tell me what the faceID value is for the PRINT icon is? I can’t find it!

ListIndex property I created a RESET button my command bar that looks at a command bar controls tab property & based on that sets the combo controls list index to zero. Public Function genericCase(intCase As Integer) Select Case intCase 'resets every combo box in "Filter Toolbar"...

Administrator problem I’m the administrator of my system & added a new user to my database security. I set him up to basically have read/design on objects like modules & forms, my goal being to allow him to view the object, but not change or delete it. I can however, delete & change objects...

How to specify password to MAKE TABLE query I’m trying to run a make table query that is supposed to create the table in another database that is password protected. Now, how do I specify this password to the make table criteria dialog box that pops up, because without it I am getting an invalid...

Select case using NOT operator I’d appreciate if somebody could comment on the below code. It doesn’t execute for a value that sets the case to true. Instead it exits to the calling procedure. GlobalUserCategory is a string and the calling procedures error handler itdentifies the error as 13 a...

Select case Zero I’m using a select case statement & am using zero as one of the values like so. Select Case glblDirCode Case 1000, 0 Now when this zero case happens, the code does not continue and execute the statements but causes an error...

Filter command bar combo box after it is created Is it possible to apply a filter to a command bar combo box control once it has been created and contains a default set of values that you want to filter further?

Cannot export report with varying textbox back color I created a report where a field’s back color is grey if it fulfills certain criteria. But as I export the report to snapshot or RTF format, the back color is not applied. How might I resolve this so the report may be sent as an email attachment?

Loop help I’m running a FOR EACH NEXT loop that examines the controls in my command bar but it fails with a type mismatch because the last one examined has been disabled and I am having difficulty thinking how I can get out of this. Here is the code. For Each ctl In...

Help on command bar I’m trying to execute the below code but get a type mismatch on one of the first statements, SELECT CASE COMMANDBARS("FILTER MENU").CONTROLS, I’d appreciate any thoughts, I changed the DIM statement so that CTL was a CommandBarControl and...