Search results for query: *

I have a form with the following fields: --------- - AcctNum - txtAppendField - btnAppend - txtNotes --------- Here's what I need to be able to do: 1) Have user type in comments/notes into the AppendField, 2) Then click the btnAppend button & have the text added to the top of the txtNotes. 3)...

Here is my code behind a command button: ------------------------------ Private Sub Command96_Click() Dim X As Variant X = InputBox("Please enter password to open this form:", "PASSWORD Prompt") If X = "5491632" Then DoCmd.OpenModule Module1.Appaoo Else MsgBox ("Sorry, you cannot update...

I know this is simple but I'm unclear how to.... ---------------------------- Have the following 2 tables: ------------------------------ tblBusinessAgreement BusinessID BusinessName FeatureID (linked to tblFeatures) tblFeatures ------------------------------ FeatureID...

I have the following code behind the DblClick on frmSearch: -------------------------------------------------------- Private Sub SearchList_DblClick(Cancel As Integer) On Error GoTo Err_SearchList_DblClick Dim db As DAO.Database Dim rst As DAO.Recordset DoCmd.OpenForm "frmMainCustomerWTabbed"...

I have a Main form with NAME1 & ACCT. I currently have a LookUp box that allows you to start typing the NAME1 and it Finds the customer. When you click Enter, that Customer's information displays fully on the Main Form. This is the code created by the LookUp Wizard...

I have a text file that is pulled off my router. I would like to : 1)Query my data listed below and, 2)Return a Query that ranks the data based on the ip address in the string. For example, I need to know that this - ip address showed up 950 times - another ip address showed up 500 times, -...

I cannot get the & to show up on my report label? My label says: ------------------------------ Save to H:\Billing\Switch CDRs - Use fielnames 14&16IN & 14&16OUT ------------------------------ But on the Report it prints out: ------------------------------ Save to H:\Billing\Switch CDRs...

I have the follwoing code behind my command button: ---------------------------------- Function Appaoo() On Error GoTo Appaoo_Err DoCmd.OpenQuery "001qryDelOldRecords", acNormal, acEdit DoCmd.TransferText acImportDelim, "14&16IN Import Specification", "14&16IN0205Template", "H:\Billing\Switch...

I have my qrySwitchDataExportToText ready to go. I can run the query, then choose File/Export/TextFile/ExportAll/ and choose my export spec called QrySwithDataExportToText and I get my text file sent to my desktop. This works great! , But I'm not having any luck adding it to my form buttons...

I have the following field in my tblTest SS7 --- 2 2 2 1 1 1 Heres what I need for my query field: ------------------------------------- If SS7 = 2 then make OrigOCN = 0000 and TermOCN = 9915 Else make OrigOCN = 9915 and TermOCN = 0000 Note: OrigOCN and TermOCN do not exist in my...

I import this text string into my text database field; Field Name : Call Arrival Date Value : 2005-02-28 08:29:14.107 How do I get rid of the .107 on the end? I would like to enter the formula in my query grid. Thanks in advance for your help! jalexander

I have a csv import file with the following fields: Call Arrival Date: Call Completion Date: ----------------------- ------------------------ 2005-02-28 08:29:14.107 2005-02-28 08:34:19.503 How do I get Access to import this as a real Date & Time field so I can calculate...

I have one table called EDIDB. It has 2 fields: ISBN & UPC. Some of the UPC fields are blank. How do I use the query grid to Update the UPC field with the ISBN when the UPC is null. Thanks in advance for your help! jlig

I have the following hyperlink string: -------------------------------------- http://shop1.gospeland.com/e/advSearch.asp?mode=search&txtTitle= IF+I+COULD+HEAR &selQuickSearch=SongTitle -------------------------------------- I want the user to be able to type a Partial song title in my txtSong...

I have an Inventory database that I manually update each week with .csv & .txt files. Here is my current procedure: ----------------------------- 1) Run "delQryAppaoo" - This deletes the old data first. 2) Import "edidb.txt" using Import Spec "APPAOO EDIDB Import...

I have an Inventory database that I manually update each week with .csv & .txt files. Here is my current procedure: ----------------------------- 1) Run "delQryAppaoo" - This deletes the old data first. 2) Import "edidb.txt" using Import Spec "APPAOO EDIDB Import...

My code below keeps giving me the ERROR 94 : Invalid Null. The debugger highlights : strSong = Me!txtSong -------- Heres my code -------- Private Sub OLEUnbound122_Click() Dim strPrefix As String, strSuffix As String, strSong As String strPrefix =...

I have a Hyper-Link txtSong field in my Access Form that allows me to : 1) Type in a song title, 2) Then when clicked, it opens up my website 3) And displays the web search results for the txtSong entry I want to change this to a Search Button image, placed right below the...

I have been given a bunch of Medical documents created in Word. My friend wants an "Electronic" version of these paper documents. Does anyone have suggestions (or sample database) to "convert" these for use in Access? Here's what I have thought so far: 1) Create tables...

I have an Access 2002 Inventory Database and want to print out Barcode Price Labels for each product on a recently received order. 1)I have a query called qryReceivedQtys to get the data 2)I created my Label Report based on my qryReceivedQtys 3)Heres my problem: Labels only print one for each...