Search results for query: *

I'm trying to hide the database window, but even though it hides it still shows the button for it on the taskbar. Can someone show what I'm missing? Version: 2002 on windows xp pro I've unchecked the show db window in the startup options, and I selected a form that has one label on in and...

I have a combobox with a list of values that the users can select. The users also have the ability to de-activate or remove items from that list to keep users from using that option on future records - the items will still exist in the source table of the combo box, they will wont be displayed...

I'm trying to set the focus on a field in the subform of a subform. This works to set the focus on a field in the first subform: Forms!frm_Main!frm_SubForm.Form.fld_ID.SetFocus There is a subform called "frm_Revisions" on the subform "frm_SubForm" and I want to set the focus on a field in...

I have a buttonfield in a gridview that I want to change the text dynamically when the row is created. Any help would be appreciated. If more information is required to answer the question, please let me know. Thanks in advance TwoOdd -------------- Good judgment comes from experience, and...

I'm getting the Error Message (see subject) on this function when varNumber actually equals an integer. Can someone help me on this? Here is my Function: Function CheckInt(varNumber) On Error Resume Next Response.Write "Number To Check:" & varNumber & "<br>" If Err.Number <> 0 Then...

I am wanting to put a button on a main form that will toggle the subform from FormView to DatasheetView and back. I have found out that the FormView has a value of 1 and DataSheetView has a value of 2, but have not been able to find the syntax to change the CurrentView value in VBA. It seems...

I have created a continuos form that is based off of a query. After I did all of the programming, we decided that we wanted the column names to read differently from the field names (i.e. instead of fldItemCode display Item Code). Not a problem, in the form field properties I left the control...

Not sure how to state this other than by showing an example. I want to create a function that will allow me to send a variable to it to reference a field dynamically. If Me.sfm_Factors![varColumn].ColumnHidden = True Then Me.sfm_Factors![varColumn].ColumnHidden = False...

I am trying to use an append query to append data to a table that has an Autonumber field as it's primary key. I am not referencing the autonumber field in the query so that access will automatically apply the number to the field. I get an error message when trying to run the append query...

This is driving me crazy. We are using Access 2000 and Access 2003. Forms will work for a while and all of sudden stop working. I'll change some code, any code, save the db, then change the code back to what is was originally and save it again and it will work again...with the same exact code...

This form works in Access 2002 but not 2003. I'm still trying to figure out what the form is trying to do, but it looks like it is trying to set the Visible property to No -- for what, I'm not exactly sure -- it gives me the following error in Access 2003: You entered an expression that has an...

First of all, let me start by saying that I'm fixing a problem on a database that I did not build and rewriting or changing the structure is not feasible. Also, this works when running the database in Access2002 or 2000, but not 2003. I have a query that pulls criteria from a form, one of the...

I created a DTS package to import an Excel Spreadsheet to SQL Server. The package runs fine by itself, but when I try to call it from a stored procedure, I get an error saying that the path to the file is not valid. The file is not located on the server. Any help would be appreciated...

The Script block lacks the close of script tag (%>). I keep getting this message even though I have the script tag closed. After getting this message, I'll go back to my page and add %> to the end of the code then save the file. Next I delete the %> I just added and resave the file then...

I'm running Windows XP Pro with SQL Server 2000. I just changed my Windows Password and now the SQL Server refuses to start. Gives me the following error message: &quot;The service did not start due to a logon failure.&quot; Any help would be appreciated! TwoOdd -------------- Good judgment...

I've read the other posts with this problem (thread916-470268 and thread916-489349), but I still can't get my card to work. I can't get the Linksys wmp11 card to work unless I log in as Administrator. Any help would be appreciated, TwoOdd -------------- Good judgment comes from experience...

I'm hoping someone can help me find a more effecient way of importing a table from one access db to another. Right now I'm setting table1 from db1 to a recordset variable. Then I loop through the recordset and insert one record at a time into table2 in db2. The two tables are identical in...

Here is what I have used to generate random alpha numeric passwords automatically. The ending result is a 6 character password that is numeric, alpha, numeric, alpha, numeric, alpha. You can add more variables if the password needs to be longer. <% 'Declare variables Dim a Dim b Dim c Dim x...