Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: markcrobinson
- Order by date
-
Adding an Item to a Drop Down List "Add New Problem"
Thank you, Can you tell me why this statement isn't working per the code referenced? INSERT INTO WCProbs (Problems) SELECT "addthis3" AS Problem; DB Name is WCProbs, Field is named "Problem"- markcrobinson
- Post #3
- Forum: Microsoft: Access Other topics
-
Adding an Item to a Drop Down List "Add New Problem"
It's a call recording database. CALLS db is one record per call A drop down "Problem" links to database PROBLEMS On the call form, user will click the drop down and select from a common problem. I would like an "Add New" Selection at the top of the list which will cause a new record to be added...- markcrobinson
- Thread
- Replies: 3
- Forum: Microsoft: Access Other topics
-
Importing or Connecting a SQL database to Access 2010
My Shopping cart is in a MySQL database on the web. I would like to bring the database into Access 2010 for Datamining. Problem is that some of the MySQL fields are 650 characters long and importing by downloading in Excel of XML format truncates these fields. Is there a way to import a MySQL...- markcrobinson
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
Convert from Vertical to Horizontal
I have a file that looks like this: Field1 Field2 ------ ------ Cust1 blue Cust1 Green Cust1 Gray Cust2 Orange Cust2 Blue Cust2 White Cust3 Yellow Cust3 Red Cust3 Green That I need to turn into this format NField1 Nfield2 Nfield3 Nfield4 ------- ------- -------...- markcrobinson
- Thread
- Replies: 1
- Forum: Microsoft: Access Modules (VBA Coding)
-
Referring to the contents of a variable
Thanks! I love Access VB, but not as much as BASIC- markcrobinson
- Post #8
- Forum: Microsoft: Access Modules (VBA Coding)
-
Referring to the contents of a variable
OK! OK! Look, I am an RTFM kinda guy. Now teach me to fish. Although I doubt anyone would believe it after seeing this dumb question I am an experienced programmer. I just forgot this... Where could I have found this myself? The new 2010 Access help files seem to return "topic not found" when...- markcrobinson
- Post #5
- Forum: Microsoft: Access Modules (VBA Coding)
-
Referring to the contents of a variable
' google import csv file has a flat file, one record per order with up to 20 items ' for Quackbooks import, I need to convert it to one line per item ordered. ' first error is If rs1.mfield > "" Then ' because rs1.mfield should be evaluated as rs1.[Item 20 ID] Set db = CurrentDb Set rs1 =...- markcrobinson
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Referring to the contents of a variable
What am I doing wrong? Set rs1 = db.openrecordset("Select [Field 1], [Field 2], [Field 3] from data1;") mcount=1 do while mcount < 4 mfield="[Field " & Ltrim(string(mcount))&"]" ? rs1.mfield ' I want the contents of mfield to be used so ' ? rs1.[Field 1] is output...- markcrobinson
- Thread
- Replies: 9
- Forum: Microsoft: Access Modules (VBA Coding)
-
Universal "Read Post Variables" Program?
EXACTLY! Thank you! Three days I've been searching for this!! For others who come across this thread: 1 - Create a file called readform.php containing: <?php echo "<pre>"; print_r($_POST); echo "</pre>"; 2 - In your form code, begin with: <form action="http://<your url>/readform.php"...- markcrobinson
- Post #3
- Forum: PHP
-
Universal "Read Post Variables" Program?
Anyone aware of a program that will allow me to read the data sent by a post form? I'm trying to debug an interface to my shopping cart and this would be a very helpful tool. Seems like an obvious utility -- but I'm not able to find it. Thanks! Mark- markcrobinson
- Thread
- Replies: 4
- Forum: PHP
