Search results

Is this just for reporting or do you actually need the * in the field? Either way you could set up a new field in a query and do this: NewField: "*" & [YourField] & "*" If you need to do it at data entry time you could do the same thing using an event as the trigger. Here is an example...

I'm not sure about any of the GW versions. The app I was using was actually a proprietary application that our company was using for HR. Have you taken a look at what the All files - (*.*) format looks like? Assuming there is some structure to the file you should be able to get it imported...

I had to do something similar to this a while back but the applications was not GW 5.5 so I'm not sure if this will work in your case If GW 5.5 has an option to export your address book to a comma delimited file you can setup a little code in Access that will grab the file and automatically add...

It's been a while since I have posted here on a regular basis. I have been cramming for VB & ASP.Net but this thread got me to thinking. Under Talismanic I logged 817 posts and now with the BukHix moniker I have 626. That is a total of 1443. Wow! Sure only about 3 of them were actually useful...

Thanks for the help everyone. While considering The_Doc_Man's solution I noticed that there was a pattern to the deletions that I hadn't noticed earlier. I am still in the process of restoring but my job was made much easier by the discovery. Thanks again.

I have two tables with exactly the same fields. There are 5 fields named: ID JobName JobNumb Location Title One tables has 4193 records and the other has 6957. The smaller of the two tables is the actual table that my application uses. Some how a bunch of records were deleted. I have an old...

VBCity has a pretty active VB 6 forum. Out of curiosity have you done any experimentation with VB.Net yet?

You should have no problem putting it on a network share then. Just make sure everyone has the correct network permissions. You will want to be careful when allowing more then 10 people at a time connect. Although I have never had that many I hear that Access can get quite slow with that many...

Are the connections between the domains all high speed?

If you are gathering the information in a web form I would think it would be a better idea to trigger the email at the time of submission. Does the server your form is stored on support ASP?

Chewy unless you just want to view your data in pieces or in one table at a time you are going to want to front end it with something. Since you are already familiar with Access it would probably be your best choice. You can do a lot of stuff to your data with EM but it is not real useful for...

The code I posted above was cut and pasted out of an Access 97 database.

Create a form with a cmd button and an unbound listbox. Name the list box LoggedOn and the command button should be UpdateBtn. Then put ths coad behind the form. This will work for you as long as the database is on a network drive. By the way I am not the original author of this code so I...

Cuba?

You use the update query to update fields in a table. Rich is right it would be easier to do it that way. Rich I prefer doing things in code because of the work I do with ASP. And I try not to rely on MS Wizards at all even when I probably should.

Hey I found this thread and it could be the answer to your problems. Check it out and let me know. ***URGENT*** DIM DB Problem

What is happening when the code is run? Is there any error number being shown?

You didn't mention the error but since you are on Access 2000 and I did mine in Access 97 I bet you do not have the reference to ADO checked. Start a new module and then go to Tools > References and make sure Microsoft DAO 3.6 Object Library is turned on. I just tried the code on a Access 2000...

So if you want to toggle the values in the table with code here is the Sub: Private Sub cmdToggleCheck_Click() Dim rsFieldCK As DAO.Recordset Dim strCheck As String Set rsFieldCK = CurrentDb.OpenRecordset("TableName") Do While Not rsFieldCK.EOF If rsFieldCK.Fields("FieldName").Value =...

On a form you would do it like this: Private Sub cmdToggleCheck_Click() If Me.chkSample = True Then Me.chkSample = False ElseIf Me.chkSample = False Then Me.chkSample = True End If End Sub To loop though an entire table you would use something like this: Dim rsFieldCK As...