Search results for query: *

Newbie here, Access programmer VBA for years but trying to learn "C" is killing me! Simple start of book exercise, Using "GCC" compiler What my code should do: Read each keyboard entry into Array called "Words" Keep accepting keyboard entries until the word "Devo" then print out each entry...

When I use an import specification (the field is TEXT) and import from a CSV file I receive a value of #NAME? for fields with values starting with a "+". Why would TransferText not be able to handle text starting with a + ? Any ideas? This process has been working correctly for several years...

Conversion of code from 2003 to 2007. I have used this code from http://support.microsoft.com/kb/198755#top for several years to show who is actually attached to 2003 MDB, IT IS PRICELESS, however it does not run now since we have converted to 2007. I made one change to the MS KM code where...

Have been given a form with a combo box which no longer works. The combo box is to show one instance of each string found in a field for ever record in a table. For example: For records "ABC-12345" "ABC-67890" "DEF-12345" "DEF-67890" should return "ABC" "DEF" one instance of everything...

I have seen this done in XL but cannot seem to come up an idea that works in my Access form on my OLE Class "Microsoft Chart Graph". I have a simple line graph based upon a query, 3 lines of data horizontal and a continuous X-Axis by Date, about 150 days at a time along the bottom. It is a...

I have a query with about 40 statements like this Like "XXX*" For example Not Like "9?9*" And Not Like "499*" And Not Like "835*" And Not Like "432*" And Not Like "47*" And .... The entire statement is together as criteria against one field. The number of characters (X's) and the value of...

My final objective is: I am attempting to place a link into an email which will open a database form to a specific record. The email receiver would click the link, the form would open and then perform some action on the record. I can create an email and insert a hyperlink but cannot get the...

Trying to create a form with unknown number of columns from a cross-tab query. If I highlight the name of my cross-tab query within the queries tab and then select the menu items "Insert" ... "Form" and then click "Autoform: Tabular" this makes the form I want, creating the correct number of...

I need a bit of code to automate the conversion of ALL linked tables (there are 65) into local tables. The idea is to take any database and use it as a testing and development file without worrying of corrupting the production data as everything is local. Ok, I know someone has a quick bit...

I need to search database code for instances of text within forms, Reports or public modules. I am attempting to find table and field names in code which may be referenced in SQL queries, dlookups etc. built into the code. I have a nice function which looks through SQL statements in queries...

I have an Input form with an AutoNumber. The user enters a new record and a popup form appears with a multi select list box. The user then selects the approporiate "SubProjects" and clicks a button to run the code below. The idea is to create ONE line for EACH SubProject. There is no join...

I am attempting to not duplicate a long Sub by passing a parameter from the "On Click" event of a command button. The command button wizard created a sub called "public Sub cmdRunReport_Click()" which has a lot of code which I do not want to duplicate for maintenance reasons. Now I need to...

I need to create copies of a record for each instance of a value (Project) found inside of one field within the record. I realize this is lousy design but I have to utilize a table I cannot change. I have a table with a fields called Document and PROJ. PROJ lists the projects for which a...

I am trying to set a combo box value and eliminate the dropdown if there is only one value remaining after a requery. Why make someone click if there is only one choice? I have 2 combo boxes, Filter1 and Filter2. Filter 2 is a list of values dependant on what was selected in Filter1, for...

I have a combo box I am using for a criteria for a recordset filter in VBA modual and I want it to work if the box is NULL or is populated I am trying to take this from a query which works fine if the Combo box is null or is populated Like "*" & [Forms]![frmDirectorsTotals]![cboDirector] I...

Is there a way to call a function that is saved in a common database, say in a shared folder? I have (inherited)a DueDate(NumOfDays) function which I use to add a code determined number of days to a date field by way of a query, sometimes 30,000 lines. This function takes into account holidays...

I am trying to loop through controls by creating a string of the control name, each loop makes a numeric value in the name advance. Something like "Control01" becomes "Control02" etc. I then use the value of this control to compare against the current date "Date" and change checkboxes if the...

The method I am trying seems to work sometimes and others with errors, I don't understand. Is my method valid or is there a better way? XP Pro, Access 97 (2003 also installed but must use 97) I am attempting to make a parameter query using criteria from Combo boxes on a form. User selects the...

I have a form with 2 subforms which worked GREAT until I moved it from my notebook with only Access 2003 to another PC with Access 2003 and Access 97 (transitioning to 2003 slowly). I can reference the field value in Subform1 using the debug window (examples below) but the source query for...

I want to add a "Null" option to my combo boxes that I use to create and apply filters. I have a form with many combo boxes which I use to filter a table within a form. I oncatenatethe combo box values together and then apply a filter. The combo boxes are populated by a query of the...