Recent content by wbwillson

Thanks, I'll give that a try! Basically I just wrap then entire procedure in quotes like standard SQL statement. Bill

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...

Sounds like you need to Stop the SQL Server services, this should release your lock file (LDF) and allow you to move the MDF file. The LDF file is suppose to prevent you from moving it. Bill

Just out of curiosity why can't you just assign it directly like: TypeKommentar.Visible = False Bill

In addition to making your application an .MDE file (which compiles all of your VBA code so others can't view it), you can make an Access application that can be distributed to people without Access installed. You have to have the Developer edition of Microsoft Office which contains the...

Chris, Althought I'm not expert at ActiveX controls...I think you could code in automatic registration. Make sure the control is copied into the system directory (I use a batch file to do this) Then register it using: regsvr32 ComponentName.dll Should work...anyone else feel free to...

All, I successfully used a DLL called PajantImage (www.pajant.co.uk). This is a really inexpensive solution $39 to register and full re-distribution rights. Only problem I have is scanning multi-page documents. I can get it to scan one page at a time and save it either in the table or...

Try running Maximize (DoCmd.Maximize) on the form's Load event and make sure you have the Pop-Up property set to Yes, this should have the form cover the entire screen and get rid of the menu bars as well. Bill

Tony, I'm using Access 2000 so maybe it is a new feature in this version. Also my forms are all single form, but could you set the code in each fields Got Focus event, and then have some code do a quick "run-through" setting the focus on all fields on the form to achieve the...

That's great, I didn't even realize it was adding a blank at the end. Bill

Tony, When in the design view of a report, selecting a field then going to the Top Menu Bar and selecting "Format > Conditional Formatting" will bring up the "Conditional Formatting" dialog box. In this dialog you can enter an expression for up to 3 criteria. Example...

I just had another thought about this, could try setting lbfields afterupdate event to: lbOutput.RowSource = "SELECT DISTINCT [" & lbFields & "] _ FROM [" & cboTableName & "] ORDER BY _ [" & lbFields & "];" I...

So are you saying that your first listbox contains for example the players last names, and you want to be able to select those last names and then when you press the move button it copies the entire name (i.e., first MI and last) to the new box? Maybe it will help if I include the code I use to...

Is your list on a form or report? You can set the conditional formatting properties for a report (or use VBA), I use this to color individual fields which are null in my report so I can quickly see what I'm missing. If its for a form you can set the color via VBA. Example: Private Sub...

I set up something similar while creating an ad-hoc report form. I have a listbox which contains field names pulled from a table. The user can select as many of the fields as they like (by holding the control key). I then have a button which moves the selected fields to another empty listbox...