Search results

Hi Jack! The solution you directed me to looks great, but how would I place the chr(34) into the middle of the string txtTest.text on either side of the quotes? Thanks for all of your help! Big Jim

Hey, Big Jim here: I have a query somewhat like this: txtTest.text = Mike's "D" Licious Salads Docmd.RunSQL(Select * FROM Table WHERE Name = '" & txtTest.text & "' ;") Anyhow, I get an error because of the quotes around the D and/or the apostrophe in Mike's pending on how I write the code...

Thanks Alan! I think I am going to build a collection to hold the data that I need. I appreciate your help. Big Jim

Hi, Big Jim here: I was hoping that I could create a recordset from a recordset. Say I have rst1 and rst2.....I want to select for rst2 only one or two fields in rst1, and I would have to use the "DISTINCT" predicate (ie SELECT DISTINCT [fields]) so that I would not have duplicate data. Is...

Hi Pat, The numeric value I am getting seems to be related to the individual's name somehow. For instance, I have 5 contracts for "Jamie", and all 5 values show up as "1", the next person's name shows up as "2" and so on. Thanks! Big Jim

Hi, Big Jim here: Ok, I don't usually use Access 2000 (97 is the norm), so I am not familiar with some aspects. Here is my dilemma... Dim rst1 As dao.Recordset Dim str1 as String Set rst1 = CurrentDb.OpenRecordset("SELECT ContactID FROM Calls;") Do Until rst1.EOF str1 =...

Ok.... I need to add some single quotes like this: strServer = Eval("GetDriveType('" & strServer & "')") Thanks for your help! Big Jim

Hmmmm, when I changed the code to this: strServer = Left(CurrentDb.Name, 1) 'Value of "C" which is needed for the function strServer = Eval("GetDriveType(" & strServer & ")") It tells me that Access can't find the name "C" I entered in the expression. Any thoughts? Thanks! Big Jim

Hi, Big Jim here: Ok, here is my problem. I try to run this code: strServer = Left(CurrentDb.Name, 1) 'Gives me "c" strServer = Eval("GetDriveType(strServer)") The problem falls within the second line of code. When I run it, I get an error telling me that Microsoft can't find the...

Ok lipin, This is what you will do: First off, you need to make sure that your form has access to all of the records. I do not know how you set it up, but hopefully my code below will allow you to see what you need to see. Create 2 text boxes: txtDate, txtCustNum Create a command button...

Hi, Big Jim here: When I copy and paste, things don't always apste as they were originally typed. For example, I might have a line that is centered and bolded, but when I copy and paste, the line is now to the left and underlined. I notice that each time this happens, it is assigned one of...

I would use the same form. Can you not scroll through previously entered records using the record tool bar provided at the bottom of the screen (hopefully)? If you can scroll through the different records, you should be able to click on the binoculars in the toolbar at the top of the screen and...

Hi kbrooks! It sounds like you need to add another field as you had suggested. Using the Social Security Number as your primary key will give you all the records associated with the SS#. You probably want to create another field called "Account #" or something like that, and use the account...

Oh goodness, sounds like you are looking for an overall tutorial of Access. ;) Let me see what help I can provide, and then maybe some other people can chime in: You have been using the tables in Access pretty much like spreadhseets it sounds like. The great thing about Access is that you can...

Big Jim here: I am copying lots of word files into one giant word file. One one particular file, when I paste it in, the font and alignment are changed. Any thoughts on what I can do to prevent this? I assume I have to set something in the document being copied, right? Thanks in advance! Big Jim

Hey Travis! Where were you like a month ago when I was crying under my desk over that one? I guess I was accessing the "selection" property of Access as opposed to Word. You are truly worthy of that picture of Hobbes which hangs beside your name! Big ol Humble Jim

Hey, Big Jim here: This one has been bugging me for a while, so here I am turning it over to our lovely forum. Here is the problem: This code is set to copy and paste from file A to file B....twice! The first time, it works great. The second time, I get an automation error...

jfgambit! Very ingenious! Big Jim is impressed with your knowledge, and he thanks you for all of your help in this thread. Thanks to everyone, and I hope this helps some other people out too! Big Jim

Thanks Fornatian. That is actually exactly what we did. I was hoping that there was an easier alternative that wouldn't require the import of a third form onto the user's computer, but it is all good. Thanks again! Big Jim

Fornation, Big Jim here: I appreciate your thoughts on the matter, but I am still having problems. Here is sample I tried to run with no luck: Forms: Test1, Test2 Test1 has 1 button on it. When I click the button, Test2 opens. Test2 runs code (in the On_Activate Event) to delete Test1. I...