Search results

I have a few forms with tab controls on them and I would like to make it easier for users to be able to see which tab they have selected. I tried adding code to the OnChange event of the tab control so that the caption for a particular tab would use all caps if the corresponding tab was...

I have a form with many, many controls and subforms on it that need to be disabled if users of a certain type enter the form. Basically, of the 30+ controls and subforms these users should only have access to 3-4 of them. Now I could go though each control and disable it like this...

?? I'm trying to make some forms and reports but the arrow keys aren't moving things around when I use them. The objects that I select just sit there. I recently installed Access 2000 on a machine. I've only used 2002 in the past. Was this feature not available in Access 2000? Anyone know...

I have some labels on a report. I would like to bold some of these labels inside of the Report_Open event if certain records that correspond to the lables contain a specific value. How would I go about doing this? I know how to open a recordset. My question is, what is the VB code to change...

I have a combo box that gets its data from a select statement. It works fine. When the form loads the combo box automatically sets its value based on the value of a variable stored in a record of the database. When the combo box changes so does the value stored in that record. What I would...

Here is what I'm trying to do.... I have a form. The form contains a subform with records in it. For the sake of argument lets assume the records consist of first and last names. The form also has a text box for the last name field and a text box for the first name field. I want to make it...

NM, got it.

I can't seem to get this create table query to work within a form. Meanwhile, if I take the exact same code and place it into a query all by itself it works!! Here is the code from the query that works (table names and variables were changed to be more generic): SELECT TableA.VariableA...

Hi there, I have two versions of a database going right now. One of them is a live version and the other is a development version. I am making changes to the development version and then importing the forms with the changes made into the live version. I've run into a strange phenomenon. I...

Hello everyone. Here is what I would like to do. Right now I have a form that outputs a csv file (which the user names) to a certain folder called 'output'. What I would like to do is allow the user to specify the location of the file in case they don't want to put it in the output folder...

Inserting portions of a table and data into another table Hello. I would like to take an entire column of values from a table (lets call it table1) and a value that a user enters on a form and merge them together and then insert them into another table. So if table1 contains...

Hello, I have a command button, which when clicked opens a document stored on a network via a hyperlink address. I would like to set up a txt box for administrators of this database so that they may enter a new hyperlink address for this command button in case the document is moved to another...

Can anyone tell me how I could get a subform to change its record source by changing an option button on the master form? I've done searches on the net and I'm shocked that I can't find this. It seems like it would be a common thing to do.

Hi guys, Hate to ask a question twice in the same day but... I'd like to know if its possible to run a query on a table with a "/" as part of a field name. I'd like to place the query in the properties/rowsource portion of a combo box. I've tried brackets and a bunch of other stuff but I...

Hello, I am trying to export a table generated by a query. I am using the following line of code to output to a file. DoCmd.TransferText acExportDelim, , MyTbl, "C:\whatever\" & ExportName & ".txt" This will generate a comma delimited text file with the results. What I would like to do is...

Hi guys, I have a form with a few text fields in it. What I want to do is have a msg box pop up if the user leaves the form and the form is dirty. The msg box would then give the user the opportunity to save the changes or cancel before moving to the next form. What I've done that works, is...

Hi guys, I have an array that I would like to sort in descending order. I've tried looking in my book and on google but I can't seem to find any information about functions that would do this. How does one sort an array in access?

Hi there. I've been having trouble with this all day and I was hoping someone could help. Here is what I am trying to do: 1) The user selects a value from a combo box. This combo box has 2 columns. The first column is a username and the second column is that user's initials. The only...

Hello everyone, I'm am fairly new to Access and I am having difficulty finding out how to do the following: I would like to search for files in a directory (by name), then display the results in a list box. I would then like to be able to double click or press a button to open a particular...

Hi guys (and gals?). I'm running into a snag with a database I am writing and I could really use some help. I'm at my wits end. I have a table that stores a patient id, a record id, 3 fields for race, and other data. The main part looks something like this. Pat_ID Rec_ID Race1...