Search results for query: *

I'm fairly new to both ASP and SQL Server 2000, but heres my problem. I have a developer PC which is not on our network, I have SQL Server installed on this machine. I want to be able to Detach the SQL database files (.mdf & .ldf) and then copy them to a CD-RW, move them to my networked PC and...

I'm trying to set up an ad-hoc report system. My basic train of thought was to have a form which lets the user select a table from a combo box, once the table is selected the available fields list box is populated. The user then selects which fields they want to see on their report. I've set...

I have a form, and on that form I have 31 Checkboxes. The idea is that the user will check the boxes for the fields he/she would like to see on a report. I'm trying to create an "Ad-Hoc" report system. How can i programmatically determine the value of the checkboxes. I know I can do it...

I've created a word doc with bookmarks that I use to populate from my tables. I need to be able to search for certain words after the merge has occured and then make those words Italic. I've tried the following code: Dim objWord As Word.Application Set objWord = CreateObject...

Is there a way to write a code to select every object on the current form? I want to be able to select every object on my form so that I can make them invisible and just turn on the fields and labels that I want. I could do this by hand by coding every field/label name but this takes tons of...

I'm trying to speed up my access database. I have a lot of VBA code as well as lots of inserted JPGs. Is there a way I can load all of my graphics files at the very start of the database? I'm thinking if I make the end user wait a bit at the beginning, it will be better than making them wait...

I've written a very large procedures which exceeds the 64Kb limit for procedures, so I get an error when compiling saying that the procedure is too large and that I need to break it up. My problem is that this procedures looks at a field on my form which stores U.S. Navy rating (which are...

Hi, I have a form which collects data which eventually gets sent to a Word document via bookmarks. I need to be able to send only the current record on my form to word. Currently if I have say 10 records in my table, when I generate the Word Doc it automatically goes to Record #1, but I'd...

I have a last name text field and I want to be able to determine if the last name is plural or not so I can add an aprostrophe. For example, if the person's last name is "Doe" then I want access to Change it "Doe's". If the last name is "Simmons" I want it to...

I'm trying to display the record numbers on a form. For example (Record 1 of 9). I've created a module with the below code. Then I set my Control Source to =hpFormRecCount() on the text box. This produces the following error "The expression you entered has a function containing the...

How can I replace the error message that comes up when a user tries to access a portion of the database to which they don't have permission. For example when a user clicks on a button on my form which runs a macro to open another form they get the following error "You don't have permission...

Access 2000 Text box I want to equally justify text in a text box on an Access 2000 report. And if i choose Distribute, on TextAlign... it works ok, unless one word or so wraps to the next line. Then it causes that one word to be equal to the size of the text box, so the letters are all...

I'm trying to open a form whose ID needs to be based on another forms ID number. I thought something like Dim strWhere As String strWhere = "[FORM1ID]=" & me!FORM2ID DoCmd.OpenForm frmNamesEntry, acNormal, , strWhere But this doesn't work...I just need Form2 to go to whatever...

I have a problem with a combo box. My Combo box looks up its values from a separate table called "contacts". When the user selects a name it appears on the form but in the actual table it has a value like 1, 2, 3 etc.. How can I get the combo box to put the actual text from the...

How can I set the field values for several fields using one combo box. Example, I have a table name SUPPLY ITEM which lists the Items Description, Item price, and Items Company. I use a drop down combo box to let the user select the items, this puts the Description value from the SUPPLY ITEM...