Search results for query: *

Hi- I think I may be dreaming here, but is there any way to recover an mdb file from the mde? It was accidently deleted. Thanks!

Hello- I am trying to pull data from the database on our server using a SQL Select statement. The criteria is a string value that is input on a user form, and the results populate a list box. Simple enough. Here's a bit of my code: Set objConn = CreateObject("ADODB.Connection")...

Hello- I'm trying this thread again, because I haven't had much luck with it... I'm trying to pull data from a database on our server and import it into a local table in Access. The only way I've found to do it is to create a recordset with the data and run an INSERT SQL statement cycling...

Hello- I'm trying this thread again, because I haven't had much luck with it... I'm trying to pull data from a database on our server and import it into a local table in Access. The only way I've found to do it is to create a recordset with the data and run an INSERT SQL statement cycling...

Hello- I'm not sure if this is possible, but I would think so... I am trying to run an INSERT INTO statement to pull data from the database on our server and insert it into a local Access table on my machine. I can't use a pass through query because the uid/pwd changes for each query and once...

Hello- I'm running XP Home OS, and I understand that IIS and PWS are not available. Does anybody know of a freeware/shareware web server that I can download that will support ASP? Thanks!

Hello- I'm running XP Home OS, and I understand that IIS and PWS are not available. Does anybody know of a freeware/shareware web server that I can download that will support ASP? Thanks!

Hello- Does the Month() function not work in VBA? Year() and Day() work just fine for me, but Month() gives me an error message...? Thanks-

Hello- Is there a way to disable the mouse wheel from scrolling through records on a form? I want my user to only be able to change records using my lookup text box. Thanks-

Hello- I've written code like this a thousand times before but have never run into this problem. Here's a small piece of what I have: strSQL = "DELETE * FROM tblOverseasAgents WHERE DAID = " & Forms!frmUpdateOverseasAgents!txtDAID I keep getting a compile error stating...

Hello- I have a combo box whose rowsource is set to an SQL statement. The SQL is SELECT Count..., so it returns a value and places it as the ItemData(0) in my combo box. I then need to use this value in an UPDATE SQL statement. Everything works fine until my SELECT statement returns no values...

Hello- I have an Access DB that allows the user to open form letters in Word and then automatically fill in name/address, etc. using the custom document properties. I want the user to be able to create their own letters, inserting fields (doc props) wherever they need to. It's a pretty...

Is there anyway to run a query that lists the field names in a table? For example, a table with fields "Mon", "Tues", "Wed" would query like this: Fields Mon Tues Wed Am I dreaming here???

Is there a limit to the number of fields I can have in a report? I keep getting an error message when trying to create a report with 48 fields. Thanks-

I have a table with 30 fields, each is field a measurement of performance (timeliness, helpfulness, etc). The values in this field are 0 ,1 or 2. There is also a formID field cooresponding to each entry. Looks like this: FormID Timeliness Helpfulness 224 0...

I know this is not difficult, but I can't seem to find the code for it... I have a textbox which is used to gather user input. A cmd button adds this value to the listbox (and the table/query on which it's based). No problems there - not too difficult. However, I want to display a msgbox if...

Hello- I want my user to be able to add options to a listbox's underlying query/table. This is no problem, but I want a msgbox to appear if the value already exists. I know this is just a line or two of code but I can't seem to get it right. Here's a bit of what I have to add the record...

I have a master form with 8 tabsheets on it. Each tabsheet will contain data from a different table, and each table is related to the main table. I think I have 2 options: 1) Create 8 subforms based directly on the tables and then place these subforms on the tabsheets, or 2) create one query...

I'm a bit new to this vba stuff, so bear with me... I am trying to save a Word template from vba into a specific folder. The template name is taken from an Access form, and I have no problem saving the template under that name. I just can't figure out how to designate the folder. Here's a...

I've been struggling to find a solution to this problem for some time now...ANY help would be greatly appreciated. I have a master database that executes Insert queries in 2 other databases. These insert queries are each based on 3 pass through queries. I have hard-coded the connect string...