Search results for query: *

I have been working for a few weeks now, but cannot seem to get the relationships working properly on this DBase. I am just now learning about normalization. When I started out, I only had one huge table. I have now separated it into several smaller tables. My problem is that I want to create a...

Hello All: I have an excel spreadsheet project that requires me to change the information from this format: Magnolia House 100 4th Ave W Oneonta AL 35121 St Martin's In The Pines 10 Woodside Dr Birmingham AL 35210 Shelby Ridge Nursing Home Rehab 1000 1st St N Alabaster AL 35007 To this...

Hello All: I need to evaluate 2 fields to add a certain # of days to a date due field. The code I am using works very well, but I will have to do this for several scenarios & thought there may be someone out there with a shorter / more efficient way of doing this. The code is below & thanks in...

Hello All! I have spent weeks trying to do this, then spent several days looking for shareware / freeware. I need a DBase to use for resource scheduling. I have certain pieces of serialized equipment that we loan out as needed, but we have had the problem of 2 people trying to loan out the last...

Greetings All: I have need to check a field to see if it contains the string "GEN" if it only contains this string the following code works great, however, almost all of the textboxes contain a 10 letter word & these three letters show up in some of them. I have tried many different variations...

I currently have a form that opens when I open the database. This form is set to continuous, it has reminders that show up, with a task list of things that haven't been done yet. There is a checkbox & a date field. I need the form to stay open until either the checkbox is ticked, showing that...

I have spent 6 days on this, I have searched every website I could find (including Tek-Tips), the help files & spoken to a few “Gurus” I know. I am trying to help the Assistant Purchasing Manager at work. Every morning, she must run 3 reports from the main computer. These reports are in CSV...

Folks, I have searched this site & others for days now & can't find anything. I hope it's not that Imissed it, I hate to ask for help when it's already been posted. Anyway, I guess that's the disclaimer - now for the problem: I have a form, that when you click on the navigation button to create...

A friend asked me to help him streamline the following code. I tried Select Case, but couldn't get it to work. The code, as it is, works - he was just hoping to shorten it. I am posting only a small amount here, but it follows this same pattern for several cells. Private Sub...

Can anyone help me with the following code? It works, but doesn't accomplish my goal. [Code]If ActiveCell.Value < 100 Then [Code] My goal is to find the cels that are equal to, or less than negative $100.00. I have searched this site, as well as the Excel help files but can't find the answer...

I have a form that is modal & popup. This is great, except that I have buttons on it which open other windows, well as you know this opens the window behind the Popup window. My question: is there a way to change the modal / popup status via VBA? If anyone has an answer I would be most...

I have a DB (Access 2000) that is split into front / back end. The problem I have is that if the program is open on one computer, you can't open it on the other one. Oddly enough, if you open it on the second computer first, you can then open it on the first one with no problem. I have checked...

I need to export as follows: [Name](in Access) = A:3 (in Excel) [Address] (in Access) = B:5 (in Excel) etc. Is this possible? Can anyone help? Any help would be appreciated. Thanks - in - Advance, Michael MichaelHadden@BigFoot.Com If you give someone a fish, you have given them a meal. If you...

I want to send the current info from an Access 2k form to an internet address. The following attempt didn't work. Can anyone advise, or at least let me know if I'm heading in the right direction. Private Sub CmdMap_Click() Dim strURL As String Dim dblHandle As Double, strCommand As String a =...

Is there any way to access (maybe through VBA) the view map button on the Outlook, or Outlook Express Contacts form. I would like to place a button on an Access2k form that when clicked will use the information on the form and act the same as the button on the Contacts form, taking the user to...

I am trying to copy ONLY the FirstName, LastName, Address & PhoneNumber to the clipboard so that I can paste it into the AlphaNumeric paging system I use at work. Any help you can offer, would be appreciated. Thanks in Advance, Michael MichaelHadden@AltaVista.Com If you give someone a fish, you...

When I delete a record in my access 2k mdb it only deletes the info in the record, but leaves an empty record. If I have 523 records, then delete one it still shows 523 records, when I look at the extra one it is just a blank form awaiting data entry. this is a fairly new development, it just...

I am in a pickle. I constantly get the error message UpDate or CancelUpdate without AddNew or Edit. The trouble is that I can’t figure out why. There is no rhyme or reason. I haven’t changed my code, and I only get this message on certain customers. Some changes are made with no problem, then...

I am currently using the transaction log(faq181-291) (By: Michael Red) to keep track of changes to records. This works great, but it keeps track of the changes by the unique ID #, and I am interested in using other fields. In other words I would like to be able to view changes based on the name...

I am using the following code, but keep getting the following error &quot;Update or CancelUpdate without Addnew or Edit&quot; Private Sub Form_BeforeUpdate(Cancel As Integer) Dim MyDB As Database Dim MySet As Recordset Set MyDB = CurrentDb Set MySet = MyDB.OpenRecordset(&quot;Updates&quot;)...