Display Record Number In Query

Recent Posts

• Enter Values In Table From Form
  • Hi, I am working on a form that uses 3 combo-boxes that are linked to populate only with the data that is related to them (basing value of control on another control). Here is an example... model # is selected, the color box is populated with the colors that are available for that model # and finally, the accessory package available for those models in those colors. I have not had any issues up to this point, but the problem comes in when I try to populate a text box with the price. I want it to be in a text box so that if this changes, an associate can easily click through the combo boxes and update the price. All of the data is being pulled from one table.Any suggestions as to how to go about doing this would be greatly appreciated. Let me know if any further explanation is required.
    page tag? Display Record Number In Query UtfBSmzaA
• Uint32 In Access 2007
  • Good evening, Ladies and Gents,I need to store an uint32 in an Access 2007 column (range 0 to4Gig-1). It appears, that A2007 does not provide uint 32 bit, nor int64 bit. But maybe I am wrong and can't see it?I hesitate to use floating point values, due to the time needed forconversions between IEEE and ints, and frankly I am also fearingpossible rounding issues (the div 0 bug is still remembered).Decimals seem to have their issues as well. At least when googling, Ifind a lot of them.So, what do you recommend instead? FieldHi for the MSB 16 bit andFieldLo for the 16 LSB? Something else?Thanks for your input.Best regards,//Donar
    page tag? Display Record Number In Query Donar
• How To Delete Or Overwrite An Attachment File
  • Can someone tell me how to delete or overwrite an attachment file which is created in the process of e-mailing a message with the attachemnt from ACCESS?I create a report which I want to attach to an MS Outlook e-mail message. In looping through the recipients I get a warning message to overwrite the attachment file. I would like to either delete the attachment after being sent or get rid of the warning message and overwrite the file with the newest one. -- frank-a
    page tag? Display Record Number In Query UtfBRlNITRU
• Aggregate Function In A Query
  • The crosstab query below works. However, I would like to add the following condition to the query: TotInv: IIf([InvType]="Cost Invoice",[TotNonUCRClaim],([ServCodeRate]*[UnitsUsed]))However, when I add the condition, I get an error that says: "You tried to execute a query that does not include the expression…as part of a aggregate function."TotInv: IIf([InvType]="Cost Invoice",[TotNonUCRClaim],([ServCodeRate]*[UnitsUsed]))This SQL for the query works fine until I try to add the condition:TRANSFORM Sum([ServCodeRate]*[UnitsUsed]) AS TheValueSELECT tblContracts.InvType, tblContracts.ContractName, Sum([ServCodeRate]*[UnitsUsed]) AS TotInvFROM (tblServicesProvided LEFT JOIN tblContracts ON tblServicesProvided.ContractName = tblContracts.ContractName) LEFT JOIN tblServCodes ON tblServicesProvided.ServCode = tblServCodes.ServCodeGROUP BY tblContracts.InvType, tblContracts.ContractNamePIVOT tblServicesProvided.CalMonth In ("July","August","September","October","November","December","January","February","March","April","May","June");Is there anything I can do to make this work?Thanks in advance!-- Nona
    page tag? Display Record Number In Query UtfBTmuYQ
• Lied
  • Welches Lied wurde um 19:50 Uhr gespieltMit freundlichen Grüßen
    page tag? Display Record Number In Query Kerstin
• Vbyesno Result To Populate Another Field
  • Hello all again.I have this following code in my program made with the help from this community. I would like now to update this code with the following questions.How do I add extra words like *steel*? Is it by adding an 'or' statement between the like and then, or do I just add another if statement?And can I update a yes/no field in same table as fldDESCRIPTION_SUMMARY by pressing the result yes?Private Sub fldDESCRIPTION_SUMMARY_AfterUpdate()Dim TheAnswer As Boolean If Me.fldDESCRIPTION_SUMMARY Like "*rail*" Then TheAnswer = MsgBox("Has rail", vbYesNo, "Result")End SubMany thanks to all that helpGraham
    page tag? Display Record Number In Query UtfBZVldmVzMTIMw
• Field Content Auto Generation?
  • Hi, I am quite new to Access and I have no idea how to solve this. I have three fields, the first field's content is say, "You". The second field's content is "Win". After I input these two fields, is there a way to let the third field automatically fill in "You Win"?btw, is there a built-in CHM reference guide for the Access 2003 syntax? I couldn't find any help file :(Thank you.
    page tag? Display Record Number In Query UtfBQJhZyBIYWNr
• Replia Set Exceed Time Limit
  • I get the following message when I open a database.This member of the replica set exceeds the max # of days allowed between synchronization and can't be synchronized with ant other member of the replica setWhen I click OK to the "Delete this replica set and create a new replica. It opens the database. I save the database and close it.The very same thing happen the next time I open the file
    page tag? Display Record Number In Query UtfBbxkamF
• Export Crosstab Query Too Many Fields Error
  • Hello all - I have a table with 6 fields and 1100 records. I use a crosstab query to view the data in the format I need. That works great. When I try to export it to Excel, however, I get an error of too many fields defined. Using the compact and repair utility does not help. I use TransferSpreadsheet in a macro to move the data to Excel. The error also occurs if I try to export from the query. Any help would be very much appreciated.
    page tag? Display Record Number In Query UtfBaRkaWQ
• How To Use A Temporary Viarable For Two Fields?
  • Hello, I have been stuck at a circular reference problem for a while now and I am trying to use a temporary viarable to transfer data between two fields to solve this. Is there a way to do this? Any help is appreciated.
    page tag? Display Record Number In Query UtfBTWVnYXRvbg
• Daily Planner
  • i'm looking for a day to ady planner with 15 minutes intervals to use as a booking screen can you hel;p
    page tag? Display Record Number In Query UtfBcFmaGlyZSBjYXJz
• Multi User Settings
  • I am running Access 2002 service pack 3 on Windows XP professional service pack 3. I have an application that is shared by two users. They can both add invoices at the same time with no problem, however when one of them goes to add another Vendor (Vendor Master Table) that is not currently listed Access will not let her add the vendor and gives her an error that someone else is using the system. The settings in the advance tab of the Options drop down are as follows: Default open mode, Shared; Default record locking, No locks; Open databases using record level locking is checked. How can set the system to allow additions to the Vendor table while another using is inputting invoices? Your attention in this matter would be greatly appreciated.-- Bruce
    page tag? Display Record Number In Query UtfBQnJYU
• Modify Unicode With Confidence?
  • I am fearful of modifying the unicode property programtically with the following snippeApplication.CurrentDb.TableDefs("Table1").Fields("Field1").Properties("UnicodeCompression").Value = TrueI have some 30 tables that participate in relationships that I would like to set uncode to yes to see if the performance can be imporved.When I set the property manually I get messages during the save "Errors were encountered during the save opoeration. "Data type were not changed." .. "Indexes were not added or changed". If I manually delete the relationship there is no issue with the save.Because of the number of changes required the VBA snippet would work well but I have no idea what is happening to the Indexes and relationships in the darkness of night so to speak. If I do it manually, first deleting the relationship and then restablishing the relationship I have a higher degree of confidence but it is a lot of steps and work I could easily mess up.Does anyone know what I can expect if I use the VBA snippet?
    page tag? Display Record Number In Query UtfBSGFybxk
• Kill Script
  • Can someone help me with this? I copied the code from the forum last week and added the hyperlink and DoCmd.Quit commands. I was deleting .mdb files. Sometimes there was one and sometimes there were many, and it always worked great. I have since converted the files to .mde files. Now it only deletes one .mde file. I can rerun it and it won’t delete any more files in that directory.Private Sub Form_Open(Cancel As Integer) Set fs = CreateObject("Scripting.FileSystemObject") If fs.FileExists("C:\ab c\new\*.mde") Then Kill "C:\ab c\new\*.mde" Else End If Application.FollowHyperlink "C:\ab c\MyProgram.mde" DoCmd.QuitEnd SubThanks.
    page tag? Display Record Number In Query UtfBQXJdXJv
• Compact And Repair - Creates New File
  • Using Access 2003 in XP Pro - recently a new file "db1.mdb" is created during each compact and repair of any database I have. It is basically a copy of the database being compacted. Did I miss reading about an issue out there or could someone tell me how to resolve this?Thanks in advance.-- Jeff CLive Well .. Be Happy In All You Do
    page tag? Display Record Number In Query UtfBSmVmZiBD
• Problems Connecting Visual Studio To Ms Access Database
  • I am trying to teach myself Visual Basic using online lessons and books,using VS2005.I created a new project, a windows forms app, with nothing in it yet but theempty form. Following the lesson plan I chose Data, Add New Data Source,highlighted 'Database', NextAn error message comes up immediately: "An unexpected error has occured.Error Message: Object reference not set to an instance of an object."I had planned on connecting to a copy of the Northwind Access database.Another error I encountered was "Format of the initialization string does notconform to specification starting at index 0."I have tried researching this but in most cases there seems to be some codethat crashes - but this database is empty - I haven't written any code yetother than what VS creates automatically.Is there something wrong with the way I installed Visual Studio? Is it abug? Did I miss a step you have to do before you can connect to a datasource? Is the problem the fact that I have an .mdb database but I amrunning Access 2007 on the PC?My questions on the Visual Studio newsgroups have gone unanswered.Mich
    page tag? Display Record Number In Query M Skabialka
• Email Form As Pdf Using Lotus Notes
  • I am trying to email a report from Access 2007I select eMail then SEND OBJECT AS report.PDFThe system initiates a new email through Lotus Notes 6.5.5 and attaches report.XLS. XLS not PDF....This file will not open in Excel. I have to save the file, change the extension back to PDF, then send it.Why would the extension automatically change? How can I stop this from happening?Thanks,Michael
    page tag? Display Record Number In Query UtfBbWlrZWFyZWxsaQ
• Forms Disappearing
  • I am working in access 2007 I was working in a form and all of the information in the form disappeared. I closed down and restarted-nothing. When I tried to build a new form it disappears as well. It shows up in design mode but not in any other mode. Any ideas?
    page tag? Display Record Number In Query UtfBeWyallbGZXIwMg
• Compatability Pack
  • I have 2003 version of Word. Installed new hard drive so lost all. Which compatability pack is needed to view 2007 Word documents.
    page tag? Display Record Number In Query UtfBSmluZXk
• Email
  • WHEN I SEND AN ARTICLE IT WILL NOT ENTER THE NAME OF THE PERSON I WANT TO SEND IT TO. AND IT COMES BACK TO SEND HAVE TO TYPE IT IN.I CAN GO TO CONTACTS AND PUSH THE PREFERRED JUST TO EMAIL AND CANT PUT SEVERAL PEOPLE ON THE LINE TO SEND
    page tag? Display Record Number In Query mabeline
• Can Anyone Explain This Intolerable Latency On A Wan?
  • I have some clients (there are about six team members) working on anAccess 2003 Front End which is connected by a WAN to an Access 2003Back End some hundred or so miles away.When the application starts there are some housekeeping operationsthat take place (some once a day when the first person logs on, otherswhen anyone logs on) before the initial screen is displayed. When theback-end used to be hosted locally the time to display the firstscreen was a matter of five or ten seconds. Now that the back-end ison the WAN it typically takes TWENTY FIVE MINUTES before the firstscreen is displayed.I've tested the network connection by copying the back-end database inits entirety onto a local machine. It's only 55 Mb and the copy tookabout 55 seconds. I've also configured the application to connect tothe local copy and it runs much, much quicker.Since the network connection *seems* ok, can anyone suggest any otherpossible candidates for the unusable latency that my clients areexperiencing? They are a small team in an enormous organisation witha very uncooperative IT Support department.ThanksEdward
    page tag? Display Record Number In Query Edward
• Main / Sub Form
  • I have a main form, the user selects the criteria and passes the parameter to the underlying query of the subform how do I refresh the sub form.
    page tag? Display Record Number In Query UtfBTyuLi
• Access 2007
  • IT recently upgraded us to Office2007. I get a message in the status bar at the bottom that says "Updating Tables. Press and hold ESC to stop..." Sometimes it pops up quickly every few seconds and slows everything down. Other times it stays up for varying lengths of time and locks the database up when it's displayed. How can I get rid if it?Thanx,Dan
    page tag? Display Record Number In Query UtfBVFyRWFnbGVEYW
• Can I Run An Access 2000 Project/Program On Access 2007??
  • I will buy the 2007 if it will run a 2000 db etc that I must use. But otherwise will not. Can whone advise me if it will run and will I be able to redesign it with 2007?ThanksGB
    page tag? Display Record Number In Query George
• Open Multiple Instances On One Pc...
  • Hi,We have a bunch of access adps used as front ends for SQL server databases and recently converted to Access 2007. The problem is that Access 2007 apparently wants to modify the adp which is causing two issues.First, because the adp is opened for writing, attempting to open a second instance forces the second instance to be opened in "read only" mode which displays a save as dialog to save a copy of the adp under a different name. Because it's connected to an SQL server for data storage, there is nothing in the adp that should be changed...so opening in read only mode would be fine if not for the warning message and "save as" option. In fact...opening in read only mode would fix the secon issue...The second issue is that we use a "loader app" which examines the date/time stamp of the adp to determine if it's the latest version. Since the file is always opened for reading...the file date/time stamp gets updated every time the adp is opened. That is interfering with our ability to determine if there is a newer version available.So...what I'm looking for is a means to suppress the read only warning. I can understand displaying a warning if it's opening the file as read only because of a file lock. But if I'm opening the file read only by using the "/ro" command line switch, do I really need a warning? It seems silly to warn me about something that I'm obviously doing deliberately. And it's down right aggravating when there is no way to override that warning.
    page tag? Display Record Number In Query UtfBUmF
• Change Background Color
  • I did the below post and it worked to highlight in yellow a job name if it is double-clicked on - but I now need to add a color-light orange(peach) - to hightlight job name - Yellow means impt for example and peach means it is done. not sure best way tohandle this. ( used blnYelHighlight) below in place of blnHoursAM - tied code to the double click on the job name field.Any ideas- see prev. post below that I used but now need to handle multiple formatting??thanks,barbAs John Goddard has said, you will need to use conditional formatting to achieve this. To be able to change the background colour of a control at the whim of the user independently of the value in the control, however, you will need to add another column to the table for each column you wish to highlight. These extra columns can be of Boolean (Yes/No) data type so that their values can be toggled between True and False, providing a basis for an expression on which to base the conditional formatting. Taking a hypothetical example lets say you have a column HoursAM which records the morning hours worked by an employee. You'd add a Boolean column to the table, blnHoursAM say. In the DblClick event procedure of the HoursAM control on your form change the value of the blnHoursAM column in the current row of the table with: Me.blnHoursAM = Not Me.blnHoursAM This simply toggles the value of blnHoursAM between False and True. You don't need to include a control bound to the blnHoursAM column in the form; it just has to be in the form's underlying table or query. To conditionally format the HoursAM control on the basis of the value in the blnHoursAM column, in the conditional formatting dialogue for the blnHoursAM control select 'Expression is' from the combo box on the left, enter [blnHoursAM] in the text box to its right (make sure you include the square brackets around the column name), and set the back colour to a colour of your choice. Ken Sheridan Stafford, England
    page tag? Display Record Number In Query UtfBYmFicw
• Two Different Characters In String
  • Hello,I am using Access 2003 and trying to create a query that separates the last name from a field of last name/first name combo. My data can look like thisJones, Adamor can look like this:Jones|AdamI currently use Left(qryMHTracking!LName,InStr(qryMHTracking!LName,",")-1) which does fine for the names with a comma in them. I cannot seem to find a way where I can evaluate both instances (, and |) to yield the last name by itself.Any help?
    page tag? Display Record Number In Query UtfBUFQMg
• Losing Sql Indexes When Linking Into Access 2000
  • Hi there-I have yet to find an answer for this issue. I have tables that are in an SQL environment that I then link into an Access 2000 database. In SQL, some indexes are created on the fields-some of the indexes are on multiple fields. The indexes are not primary and not unique. For some of the tables, when I create the linked table, I get the indexes coming in just fine. I never select a unique record indicator when prompted since there are rarely instances where any field is 'unique' in that way (any of them give me the primary key if I were to click on them which would mess with how the data is presented). The problem is that some of the tables, which I know have indexes on them in SQL-do not have the indexes coming along with them when I link them in Access 2000. Previous versions of the database, in Access 2000, have not had this issue. The version of SQL is also the same. I am stumped as to what can be causing this-is it a 'bug' in Access 2000 or in SQL? Any other ideas would be welcome-thanks so much!-- Thank You,Matt Henshaw
    page tag? Display Record Number In Query UtfBbWhlbnNoYXcNg
• Row Height (Different For Each Row)
  • I am collecting data, example:record1: "this is a short sentence"record2: "this is a longer sentence that will need to wrap when displayed..."record3: "another short sentence"I would like to display them on a continous form with the text field above and a few buttons (on each row)However I would like each row to grow to the appropriate size to display the text.So the user would see three rows and the middle one would have a larger row height than the other two.The buttons on the form would allow the user to open the record, and do other operationsNote: I'm trying to simplify what is needed a bit.I'm having a brain fart today, and can't figure out a good way to display records that have various sizes (and I want the entire text to be shown).Access2007, can't use any third party controls.I tried the CanGrow property.Any help is appreciated,Mark
    page tag? Display Record Number In Query Mark Andrews
• Timesheet-Bind An Unbound Text Box Expression To A Table
  • A form based on t-TimeSheet has an unbound textbox with an expression to calculate time worked for that entry. I would like to bind that value to the underlying form table...but i have read it is wrong to store a calculated value. I do need to have a historical record of a person's timesheet with totals. What is the best way to do this?Simply as a report summary based on a query, say, q_PayPeriodHoursperEmployee?Thanks for any help!Billiam
    page tag? Display Record Number In Query UtfBQmlsbGlhbQ
• How Do I Cahnge My Profile?
  • I ahve a new e-mail and I need to phase out my old e-mail.Where do I change my e-mail to sign in to the Microsoft websites Newsgroups that I visit occasionally using Intternet Explorer?Thanks in advance.
    page tag? Display Record Number In Query UtfBTNYXZpbw
• 2007 Navigation Pane Scroll Problem
  • All of a sudden when I click in the scroll bar area to go up or down the scroll bar starts jumping around for several jumps before it comes to rest in a random position.
    page tag? Display Record Number In Query UtfBTWlhdGFNWDU
• Tesste
  • teste
    page tag? Display Record Number In Query Aristides Junior
• Having Trouble With Percentages
  • I am inputting data on the table and for some reason when i set the format to number and percentage anytime i put in a percent (i.e. 94) it automatically changes it to 100%Anyone know how to fix this( im new to access so a step by step would be helpfulThanks alot everyone
    page tag? Display Record Number In Query UtfBQmxZWxpbmVyOTc
• Default
  • I have a List box called "lstOutcome". This list box is tied to the Outcome Table. Within this Table, there are two columns, Outcome and Results. See Example Below.Outcome ResultAnswered Question CompleteEscalated Issue UnresolvedIf I pick Answered Question from lstOutcome, I want to have my combo box field called "Status" default to the Result. In this example, lstOutcome would say Answered Question so my Status field would default to Unresolved. Status is set up as a Value List with options "Complete" Or "Delete". What would I need to add to the default value for my Status field?
    page tag? Display Record Number In Query UtfBUGFzcyaGUtUmVhbGleQ
• Jpb
  • why did you put lotus notes email and oh, ya what does lotus notes email mean?
    page tag? Display Record Number In Query T
• Is This Possible ??
  • Hello guys,I have a text field with descriptions as follows:SPOT TWIST GU10 50W BLIS 16751LAMPTB 400W E40 GE MHL 30052I want to format them as such so that the last 5 digits of the string diplay as follows:SPOT TWIST GU10 50W BLIS *****LAMPTB 400W E40 GE MHL ***** How should I do this?Thanks in advance!
    page tag? Display Record Number In Query UtfBRWFybCBSEgSiBbGxhZGllbiBpbiBhYNlcMgZmydWhIQ
• Mail Merge Into Ms Word
  • I used this site to get examples of Mail Merge code. Below you will find my existing code that works just fine. It is used to print graduation certificates for classes. The problem is the boss does not like the idea that up to 24 different word docs get opened instead of one big combined document. Everytime I try to change something I just get into more trouble. I have a MS Word templete that I use to big the certificates. Should I make a templete with upto 24 grad certificates in it? There just seems there should be an easier answer. Thank you for any help you can provide.If Me.optCert = -1 Then Set mysetgrad = db.OpenRecordset("tblGradRoster", DB_OPEN_TABLE) ' Open table for reading. Debug.Print mysetgrad.RecordCount iSSN = mysetgrad![SSN] Do Until mysetgrad.EOF If mysetgrad!PrintCERT Then ' Refresh querydefs collection db.QueryDefs.Refresh DoCmd.SetWarnings False strSQL = "SELECT [tblACO new].SSN, Right([tblACO new]!SSN,4) AS LAST4, [tblACO new].LNAME, [tblACO new].FNAME, " strSQL = strSQL & "[tblACO new].MI , [tblACO new].SUFFIX, tblGradRoster.COURSE, tblGradRoster.CLASSNO, " strSQL = strSQL & "[tblSchool Schedule new].GRADUATE, [tblGrade new].[Long Title], tblGradRoster.TITLE, " strSQL = strSQL & "tblGradRoster.PMOS, tblGradRoster.CID, tblGradRoster.[CE ID], tblGradRoster.Version, " strSQL = strSQL & "tblGradRoster.Length, tblGradRoster.EXHIBIT, tblGradRoster.LEARNING, tblGradRoster.INST, " strSQL = strSQL & "tblGradRoster.CRED, tblGradRoster.CREDIT, tblGradRoster.CREDIT1, tblGradRoster.CREDIT2, " strSQL = strSQL & "tblGradRoster.CREDIT3 , tblGradRoster.CREDIT4, tblGradRoster.CREDIT5, tblGradRoster.CREDIT6, " strSQL = strSQL & "tblGradRoster.MILGUIDE, tblGradRoster.MILGUIDEWEB, tblGradRoster.Revision " strSQL = strSQL & "FROM [tblSchool Schedule new] INNER JOIN (tblGradRoster INNER JOIN ([tblGrade new] INNER JOIN " strSQL = strSQL & "[tblACO new] ON [tblGrade new].Rank = [tblACO new].RANK) ON tblGradRoster.SSN = [tblACO new].SSN) " strSQL = strSQL & "ON ([tblSchool Schedule new].COURSE = [tblACO new].COURSE) AND ([tblSchool Schedule new].CLASS = " strSQL = strSQL & "[tblACO new].CLASSNO) AND ([tblSchool Schedule new].COURSE = tblGradRoster.COURSE) AND " strSQL = strSQL & "([tblSchool Schedule new].CLASS = tblGradRoster.CLASSNO) " strSQL = strSQL & "WHERE ((([tblACO new].SSN)= " & iSSN & "));" Debug.Print strSQL Set rst = CurrentDb.OpenRecordset(strSQL) With rst If Nz(.Fields("MI")) = "" Then If Nz(.Fields("SUFFIX")) = "" Then strName = Nz(.Fields("LONG TITLE")) & " " & Nz(.Fields("FNAME")) & " " & Nz(.Fields("LNAME")) & " XXX XX " & Nz(.Fields("LAST4")) & "/" & Nz(.Fields("PMOS")) Else strName = Nz(.Fields("LONG TITLE")) & " " & Nz(.Fields("FNAME")) & " " & Nz(.Fields("LNAME")) & " " & Nz(.Fields("SUFFIX")) & " XXX XX " & Nz(.Fields("LAST4")) & "/" & Nz(.Fields("PMOS")) End If Else If Nz(.Fields("SUFFIX")) = "" Then strName = Nz(.Fields("LONG TITLE")) & " " & Nz(.Fields("FNAME")) & " " & Nz(.Fields("MI")) & " " & Nz(.Fields("LNAME")) & " XXX XX " & Nz(.Fields("LAST4")) & "/" & Nz(.Fields("PMOS")) Else strName = Nz(.Fields("LONG TITLE")) & " " & Nz(.Fields("FNAME")) & " " & Nz(.Fields("MI")) & " " & Nz(.Fields("LNAME")) & " " & Nz(.Fields("SUFFIX")) & " XXX XX " & Nz(.Fields("LAST4")) & "/" & Nz(.Fields("PMOS")) End If End If strCOURSE = Nz(.Fields("TITLE")) strCOURSE1 = Nz(.Fields("TITLE")) strCOURSE2 = Nz(.Fields("TITLE")) strCLASSNO = Nz(.Fields("CLASSNO")) strDAY = Nz(.Fields("GRADUATE")) strMONTH = Nz(.Fields("GRADUATE")) strYEAR = Nz(.Fields("GRADUATE")) strACE = Nz(.Fields("CE ID")) strCID = Nz(.Fields("CID")) strVERSION = "Version " & Nz(.Fields("VERSION")) & ": " & Mid$(strCID, 4, 3) strLENGTH = Nz(.Fields("LENGTH")) strEXHIBIT = Nz(.Fields("EXHIBIT")) strLEARNING = Nz(.Fields("LEARNING")) strINST = Nz(.Fields("INST")) strCRED = Nz(.Fields("CRED")) strCREDIT = Nz(.Fields("CREDIT")) strCREDIT1 = Nz(.Fields("CREDIT1")) strCREDIT2 = Nz(.Fields("CREDIT2")) strCREDIT3 = Nz(.Fields("CREDIT3")) strCREDIT4 = Nz(.Fields("CREDIT4")) strCREDIT5 = Nz(.Fields("CREDIT5")) strCREDIT6 = Nz(.Fields("CREDIT6")) strMILGUIDE = Nz(.Fields("MILGUIDE")) strMILGUIDEWEB = Nz(.Fields("MILGUIDEWEB")) strREVISION = Nz(.Fields("REVISION")) .Close End With strDAY = Format(strDAY, "d") strMONTH = Format(strMONTH, "MMMM") strYEAR = Format(strYEAR, "yyyy") If strDAY = "1" Or strDAY = "21" Or strDAY = "31" Then strDAYext = "st" ElseIf strDAY = "2" Or strDAY = "22" Then strDAYext = "nd" ElseIf strDAY = "3" Or strDAY = "23" Then strDAYext = "rd" Else strDAYext = "th" End If strName = UCase(strName) strCOURSE = UCase(strCOURSE) strCOURSE1 = UCase(strCOURSE1) strCOURSE2 = UCase(strCOURSE2) On Error Resume Next Set objWord = GetObject(, "Word.application") If err = 429 Then Set objWord = New Word.Application End If On Error GoTo 0 With objWord .Visible = True If Me.optCO Then 'Set doc = .Documents.Add("X:\Company dbase\Blank Forms\DIPLOMAsigned.dot") Else Set doc = .Documents.Add("X:\Company dbase\Blank Forms\DIPLOMA.dot") End If ' Fill the above Word Template with the below bookmarks information With doc.Bookmarks .Item("DAY").Range.Text = strDAY .Item("DAYext").Range.Text = strDAYext .Item("CLASSNO").Range.Text = strCLASSNO .Item("MONTH").Range.Text = strMONTH .Item("NAME").Range.Text = strName .Item("COURSE").Range.Text = strCOURSE .Item("YEAR").Range.Text = strYEAR .Item("ACE").Range.Text = strACE .Item("CID").Range.Text = strCID .Item("VERSION").Range.Text = strVERSION .Item("COURSE1").Range.Text = strCOURSE1 .Item("COURSE2").Range.Text = strCOURSE2 .Item("LENGTH").Range.Text = strLENGTH .Item("EXHIBIT").Range.Text = strEXHIBIT .Item("LEARNING").Range.Text = strLEARNING .Item("INST").Range.Text = strINST .Item("CRED").Range.Text = strCRED .Item("CREDIT").Range.Text = strCREDIT .Item("CREDIT1").Range.Text = strCREDIT1 .Item("CREDIT2").Range.Text = strCREDIT2 .Item("CREDIT3").Range.Text = strCREDIT3 .Item("CREDIT4").Range.Text = strCREDIT4 .Item("CREDIT5").Range.Text = strCREDIT5 .Item("CREDIT6").Range.Text = strCREDIT6 .Item("MILGUIDE").Range.Text = strMILGUIDE .Item("MILGUIDEWEB").Range.Text = strMILGUIDEWEB .Item("REVISION").Range.Text = strREVISION .Item("SIGN").Range.Text = strSIGN End With End With objWord.Activate End If mysetgrad.MoveNext If mysetgrad.EOF Then Exit Do End If iSSN = mysetgrad![SSN] LoopEnd If
    page tag? Display Record Number In Query UtfBTWFydGlu
• Filter A Form Using A Combo Box And A Macro
  • I have a form with a combo box called "KeyIndicator" with four selections ("All"; "Key Deliverable"; "Work Plan"; "Other") - simple enough stuff - I use this combo box to categorise records in my form.I want to set a second combo box that will allow me to select one of the same four criteria but will filter the records on the form so that I can scroll through one category only (does that make sense?)I set up an unbound combo box and named it "KeyFilter" with the same four selections (i.e. "All"; "Key Deliverable"; "Work Plan"; "Other"). I then wrote a macro called "OpenKeyFilter" with the folowing argument (used "Key Deliverable" as an example): -Macro Name OpenKeyFilterCondition [Forms]![Issues]![KeyFilter]="Key Deliverable"Action ApplyFilterWhere Condition ([Forms]![Issues]![KeyIndicator]="Key Deliverable")The macro is set to run on "AfterUpdate" in the "KeyFilter" combo box.This doesn't appear to work and I suspect I'm making a silly mistake but I can't figure it out, the filter action looks like it works but it doesn't filter on the "Key Deliverable" selection.The filter "All" was easy as I simply used the "ShowAllRecords" Action and it works OK.Any help would be appreciated and thanks in advance.John Taylor
    page tag? Display Record Number In Query John Taylor
• Notinlist Event Issue
  • Is it possible to utilise the notinlist event to add a new recordWITHOUT using a msgbox for confirmation and WITHOUT opening a form toadd the data. I wan't to be able to enter new data in a combobox andhave it added automatically without the user having to do anythingelse. I realise this is prone to errors but it is for a very specificpurpose.
    page tag? Display Record Number In Query BobbyDazzler
• Where I Can Set The Access 2007 Temporary File Area For Pdf Exports?
  • Annoyingly, Access uses the destination directory to store a .TMP file when you're exporting to PDF and overwriting a preexisting PDF. It's only momentary, but it's long enough for Sharepoint to notice the file and send me an alert about a new file addition, the .TMP, in addition to the actual file I'm exporting (I have alert monitoring set on the Sharepoint directory).If there was a way to set Access to use a different directory, then I could avoid the problem.Thanks
    page tag? Display Record Number In Query Milhouse Van Houten
• Logging Incremental Changes
  • I have several tables of thousands of records each. The data isimported daily from excel sheets or flat files that I receive from thedata originator. Because the data set is so large, I can only keep thefull set of the current data. But it's become increasingly importantto find a way to log any changes that are made to the data from day today.The best advice I've received so far is to try the DISTINCTROWpredicate in SQL. That would be great if we weren't talking about somany records. Not only would I exceed the limits of Access in shortorder, I would also be storing a lot of redundant data.What I really would like to end up with is a log table for each maintable that is almost an exact copy. The difference would be that thefields in the log table would only be populated if they are differentfrom the previous day's data.For example, given an initial record for a particular employee in themain table like the following:tbl_empdate_imported emp_id emp_loca emp_health emp_rating09OCT2010 FB6K2 Georgia Green GreenAfter several weeks of imports that replace the original, the recordin the main table will look like the following:tbl_empdate_imported emp_id emp_loca emp_health emp_rating21OCT2010 FB6K2 Florida Yellow RedI want to end up with a change log that looks like the following:tbl_emp_chg_logdate_imported emp_id emp_loca emp_health emp_rating09OCT2010 FB6K2 Florida11OCT2010 FB6K2 Yellow15OCT2010 FB6K2 Red21OCT2010 FB6K2 YellowIf I were editing the data myself, I would just create a changetransaction log as there are a variety of strategies on the subject.But I need a way to compare field for field changes during the import,and then log only the fields that differ from the existing data,thousand of records each day.I have a couple of ideas to approach it, but I'm pretty sure there's amore efficient way than FOR - EACHing through each field of eachrecord. It would not only take a long time, but I've already run intoproblems writing code that tries to step through every field of everyrecord in such a large data set.Even if someone that recognizes this as a known problem set and couldrecommend search terms that would help lead me to the right path, Iwould be so thankful. My searches and brainstorming are coming upempty.
    page tag? Display Record Number In Query Mac
• Records Locking
  • I have an .mde file that is being used by multiple people. 135 within a 4 hour period. It's been locking up intermittently on them when they try to edit the yes/no field in a form. Is there any other tips to fixing that besides creating a new .mde file for them or could it be related to the back end database?
    page tag? Display Record Number In Query UtfBSmFrZSBG
• Monthly Reports - Macro Count
  • Hello community ^_^ I'm in the need of some help!I got 2 questions that hopefully you guys can help me find the answerFirst,The function of the database is to store the information of printer cartridges. We normally do storage count every month, so I need a report to print out how many cartridges were used based on the count in the storage room and the new count. So basiclly OldCount-NewCount.NewCount: will be inputted by user.Total Used: NewCount-OldCountOldCount: after the calculation, it will then get the value from NewCountHow can I be able to do that in a form?Second,I would like to know how can I create a report that will ask me an StartDate and an EndDate and depending on the info inserted it will display the records. This is to display the TOTAL USED cartridges used per month.Database Structure:- Table (Storage) the table contains these fields: Manufacturer, Model, Category (all referring to the cartridges) a field for Storage (I use this for oldcount) and the Count field (we can use this as newcount), Total Used (empty, but on the query I set it as Storage-Count) StartDate and EndDate fields empty.- Form (Storage) is based on the Table.- Query (Storage) displays all fields from the table.I really appreciate any help, and I'm willing to mail a copy of the database if anybody wants to take a deeper look into it.~Manny
    page tag? Display Record Number In Query UtfBTGjbJhbnM
• Xccxcx
  • 
    page tag? Display Record Number In Query george
• Inventory Program
  • Another problem. I have several calculated fields on my Enter Products form. I would like to have these calculations entered on the Products2 table but they leave the corrasponding fields blank.TotalValue = (([NuPrice] + [CuPrice] / 2) * [UnitsInStock]This fills in the Total Value of Current Stock field on the form but does transfer the result to the Products2 table.
    page tag? Display Record Number In Query UtfBSHViYnlNYXg
• Export Schema Problems
  • I'm working on some code to export the schema from an mdb. It's not letting me get the info on queries that are embeded in form dropdowns, list boxes, etc. Dim qd As QueryDef For Each qd In db.QueryDefs Application.ExportXML ObjectType:=acExportQuery, DataSource:=qd.Name, SchemaTarget:=sWhereToStore & qd.Name & ".xsd" Next qdWhen the above code runs it works fine except for what I mentioned. When it gets to a query that's in a form it tells me the query doesn't exist. For example in a form called "frmAddEditCertHolders" I have a combo box for states where the source for the query is just something like "Select * from tblStates". The name of the query for the combo ends up being this: ~sq_cfrmAddEditCertHolders~sq_cStateCode. If I do a debug.print qd.SQL it gives me the SQL for it but I want more than that. How can I get ExportXML to recognized these queries?When I run ExportXML on my forms, it doesn't give me any embeded query information.It also only lets you export xml for Select, Crosstb and Union queries. Why is this so limited??? How can I get around this?Thanks,Keith
    page tag? Display Record Number In Query Keith G Hicks
• Updating/Changing Mde Databases
  • I am using an FTP process for transferring data. In the past I have done this several times using mdb databases. The user would download a file, the file would open and perform certain functions, close and open a different database.Using this system I was able to get new forms, tables, queries, etc. to the users. In the Autoexec macro of the file they downloaded and opened. I would use the copy object method to export new objects to the other databases. I am now using a similar FTP methodology but with mde files. Is there a way to export to and/or replace objects in an mde file, or do I have to replace the entire file? This is a very complex program. The FE is 450 mb. Is replacing the entire FE the only way to make changes in the mde files?Thank you for your help.
    page tag? Display Record Number In Query UtfBQXJdXJv
• Planning A Table To Avoid Adding Fields
  • The Exposition -- I am currently planning out a new Access 2007database. I have already built a prototype, but have started over toaccomodate changing needs. I am a relative amateur, with someexperience but not much in-depth Access work (this is my first ventureinto 2007). I have what seems like a really simple question that I'mhaving trouble wrapping my head around. DB planning and efficienttable relationships are sometimes like advanced physics to me.The Question -- The dbase is a usage tracking system. Part of it willkeep count of how many learners of a particular type came in for eachexercise.For instance, "3 doctors, 4 medical students, and 7 nurses came in forlife support training."Is there a way to store this information without having a seperatefield in the exercise table for each learner type? That seemsungainly to me.I am trying to think of an efficient way to allow the end user to addadditional learner types, and it seems like adding new fields totables would be excessive.Thank you for any assisance,Eric B.
    page tag? Display Record Number In Query Eric D Braden
• Access 2007 Interface Controls
  • I'm having a great deal of trouble trying to set the interface tolimit what users can do and see. I've come across one web site whichdetailed code for creating/setting database properties, but even thencertain interface properties are over ridden by user's settings.My 2 main issues are hiding the navigation window, and making theprint command available (from the ribbon or menu) while disabling (orhiding) most other commands.I'll continue to search forums and the web, but if anyone wants toshare their approach to the 07 interface, I would like to hear aboutit.THANKS!David G.
    page tag? Display Record Number In Query David G
• If Statement In Access ?
  • Hi,I've been using the IF statements in EXCEL.Now I need it to work for Access 2007.Here is what I am working with:I have 2 columns with dates.I want to compare the two columns and have access give me the oldestdate.Once I get the oldest date, i want to update it into another table.Can anyone help?
    page tag? Display Record Number In Query lil lam
• Hohj
  • 
    page tag? Display Record Number In Query marti misselis
• Iif & Qrycount
  • Hi,I would like to be able to use a single command button to either viewrecords on a form if they exist or go to a new record form if theydont. I've created a qryCount but when I tried adding this to mysearch form it restricted search results to a single return and I'vetried using If then else in VBA but have gone wrong there too.Any help would be appreciated.DonH
    page tag? Display Record Number In Query don
• Limit Future Queries To Read-Only.
  • I want to give certain users access to Access's query builder, butprevent all data changes. Can I monitor the query builder and stop anyaction queries?The data resides in a back end file. Switchboards are used fornavigation, so I have an easy access point for controlling theapplication.=20THANKS!David G.
    page tag? Display Record Number In Query David G
• Query Table Based On Results From Second Column
  • Hi all,I have an Access table with some DNA sequences in it that I want topull some data out of but can't do it conveniently. This is what Ihave.A table with the following 4 columns:Sample_region (Sample name plus region (category)), Sample,region,sequenceSample_region is unique, sample is not because I have multipleregions.I want to query by sample and add all sequences that are either A or Bregion and put them in one record. For example a record would be[sample],[region A sequence],[region B sequence]. The way I am tryingto do it gives me multiple records with the same sample name. I thinkthat I basically want to add a search criteria for the sequence columnthat selects either A or B.Any help would be greatly appreciated.Wade
    page tag? Display Record Number In Query mrwawa
• Access 2003 Runtime Bugs For Sum()
  • Hello,I stucked in trouble recently preparing for distrubute MS Access 2003 Application(mde) with 2003 runtime module.The function SUM() isn't work properly if a table has mulit rows. if mouse over the issued row, then it calculated.If update Office SP1,2,3, it works, which means MS already know the issue.My application is running with Access 2003 runtime all the time evenif user already have Office installed.Problem is that a user who has Office 2003 product and already updated Office SP, after installed our product, need to update again to fix runtime bugs. This is very weird for users becasue they somethimes need to install SP twice.Any body had a same problem and fix it?
    page tag? Display Record Number In Query UtfBUFuZw
• Time Card Creation
  • I found something in MS Access and don't know how I need to proceed as I am trying to create a time card database for a group of associates to log in, log out for lunch, log in for lunch, log out, without them entering the time but a system generated time be used (to keep everyone honest).I also need it to calculate the hours for the day that the associate worked.Here is what I found in 'help': You can also store the date and time values as numbers when you plan to perform calculations on the date and time data. For example, you can calculate a total number of hours worked (a time card), or the age of an invoice. For more information about how to calculate date values, see the article on the Date function.Can anyone help me to proceed?Harriet
    page tag? Display Record Number In Query UtfBSGFycmlldA
• Problem With Ie8 Instalation
  • I've got a windows XP starter edition in my PC and i'm trying to install the internet explorer 8 but I receive from the PC warning saying that the installation don't give the suport to actual operational sistem language and for that I am not able to install the ineternet explorer 8. What do I have to do?
    page tag? Display Record Number In Query UtfBTHVpeiBNYWNvbGE
• Requisition Form
  • I have designed a Requisition form to record products delivered to customers. My problem is that I can only include 1 input line for products delivered. Quantity Ordered, Unit Type, Product Number, Product Description, Quantity IssuedHow do I enter more than 1 item for the same for the same Requisition and have all items saved to the tabe as being part of the same Requisition?
    page tag? Display Record Number In Query UtfBSHViYnlNYXg
• Printing Too Many Copies
  • I have set up a report that is actually just an information/direction sheet for my scheduling assistants. I all the margins are correct, it does not have a header or footer. When I go to print preview it comes up with 188 pages, and it is only a 2 page report; I am getting 94 sets of the same report. I have noticed this happening to me a lot latly and wonder if I have screwed up some setting some place. I have done every thing I can think of, looked at all the properties, but cannot figure this one out.Can someone out there help with this? Oh, I am useing Access 2007ThanksJaqueline
    page tag? Display Record Number In Query UtfBSmFjcXVlbGluZQ
• Alessio
  • 
    page tag? Display Record Number In Query Alessio
• Query About An Append Query
  • I hope that makes sense!I have four tables as follows:tblMainData contains transactional data that has to be manuallyprocessed.tblActionDetails contains the status of each transaction that can /has been processed.tblStatus contains the four status codes, 1 - 4.[tbl_All For Team Stage 001] contains new transactional data thatneeds to be appended to tblMainData to be worked.tblMainData has a 1:1 with tblActionDetails - Both tables have aprimary key that is the same in both tables.tblActionDetails has a many:1 with tblStatus - The Status field intblStatus is the primary keyI'm trying to write a query that will take data from [tbl_All For TeamStage 001], a new table, and append it to tblMainData, whilst at thesame time, creating an entry in tblActionDetails, with a 'Status'value of 1, to indicate that it is a new account.[tbl_All For Team Stage 001] may contain some data that is already intblMainData, so that data should be excluded. I couldn't get anappend query working to do this, so I split it into two queries...oneto select the transactions to be processed from [tbl_All For TeamStage 001], minus those already in tblMainData, and then a second onethat uses the results of this query to append the data to tblMainData.So, my queries SQL looks like this:Select Query:INSERT INTO tblMainData ( PPMIP, MeterType, MPAN, NumberOfPayments,ValueOfPayments, FirstPaymentDate, LastPaymentDate, OriginalMSN,ModifiedMSN, MeterInstallDate, MeterRemovalDate, SupplyStartDate,SupplyEndDate, Imported )SELECT [tbl_All For Team Stage 001].PPMIP, "K" AS MeterType, [tbl_AllFor Team Stage 001].[MPAN Core 1] AS MPAN, [tbl_All For Team Stage001].CountOfAMT AS NumberOfPayments, [tbl_All For Team Stage001].SumOfAMT AS ValueOfPayments, [tbl_All For Team Stage001].MinOfDATEASDATE AS FirstPaymentDate, [tbl_All For Team Stage001].MaxOfDATEASDATE AS LastPaymentDate, [tbl_All For Team Stage 001].[Meter Id (Serial Number)] AS OriginalMSN, "" AS ModifiedMSN, [tbl_AllFor Team Stage 001].[MinOfDate of Meter Installation 1] ASMeterInstallDate, "" AS MeterRemovalDate, [tbl_All For Team Stage 001].[Supplier 1 Start Date] AS SupplyStartDate, "" AS SupplyEndDate, Format(Now(),"dd/mm/yyyy") AS ImportedFROM [tbl_All For Team Stage 001] LEFT JOIN tblMainData ON [tbl_AllFor Team Stage 001].[MPAN Core 1] = tblMainData.MPANWHERE ((([tbl_All For Team Stage 001].PPMIP)="KACTA") AND((tblMainData.MPAN) Is Null));Append Query:INSERT INTO tblMainDataSELECT qSel_NewAccountsToAppend.*FROM qSel_NewAccountsToAppend;I hope this all makes sense?So, my question is, I need the append of new data to tblMainData, toalso create a corresponding entry in tblActionDetails with the'Status' field set to 1.Your help is appreciatedMany TIADuncs
    page tag? Display Record Number In Query Duncs
• 123
  • hi!
    page tag? Display Record Number In Query yu
• Happy
  • ¿ìÀÖÿһÌì
    page tag? Display Record Number In Query happylulu
• Wangganghaha
  • 
    page tag? Display Record Number In Query wangdan
• Wodedaxueshenghuo
  • 
    page tag? Display Record Number In Query wang hong
• Ddfff
  • 
    page tag? Display Record Number In Query ZHU XIAO XIAO
• Populating Main Form After Changing Selection
  • On my main form I have fields displaying ticket #, group name ticket is assigned to and phone number for respect group. If I don’t have a phone number I am not displaying field for phone number.On same form I also have a subform on which I am displaying only open tickets.After clicking on ticket in a subform ticket is populated to fields in a main form, however in addition I would like to populate fields for a phone number or make them invisible when there is no phone number.Here is a code I am using:Private Sub Form_DblClick(Cancel As Integer)Dim lngTicket As LonglngTicket = Me.[Ticket #]Me.Parent.RequeryMe.Parent.Recordset.FindFirst "[Ticket #]=" & lngTicketForms![Remedy Tickets]![Status].SetFocusEnd SubI have a combo box I called Assignto and after selecting specific group phone numbers are provided for each group. I noticed that when I select specific ticket from subform main form is populated, but when I changed assigned group, phone number doesn’t change and it is a previous selection phone number. How I can update phone numbers when I want to change group name? Thanks
    page tag? Display Record Number In Query UtfBRJlZw
• 2 Questions
  • My first is, when I open certain databases normally, I can right click on a form, table or query and go to design view, or click file and at the bottom select the database I am in and it shows the objects, however in some databases I have to hold shift to do this. What is causing this to happen and how do I turn it off?My second question is, I am trying to import an excel spreadsheet onto a table. The table and the spreadsheet have 2 fields, SSN and NAME, SSN being the pk. I keep getting an error saying "field F1 doesn't exist in the destination table". Please advise-- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".
    page tag? Display Record Number In Query UtfBTkFT
• Report Paging Problem
  • Access 2007 running on Windows XP. Report is a multipage letterformat and Access is not handling paging correctly when a text field,which can span multiple pages, is followed by a page break and finalpage. The letter report is called from a form where the text isentered. Here's what happens: If text can fit on a single page thereis no problem. If text grows and extends to the next page, a blankpage is displayed after the text and then the final page isdisplayed. Access gets confused calculating the number of pagestoo. It includes the blank page in the current page count but thetotal page count doesn't include the blank. For example if 5 pagesdisplay, the footer will display page 4 of 4 on the blank page andpage 5 of 4 on final page! note: When the page break is removed,there is no problem.Also I tried getting the text from a database column rather than fromthe form but still the same problem.
    page tag? Display Record Number In Query bontemps
• List All Data On Subform
  • I am trying to get one of Albert's functions to work. Albert's code was written for Access 2003. I am sure that my problem is with the periods and bangs.The function needs to display all people's names in the field "PersonnelName" on the main form that appear on the subform "subfrmProjectPersonnel" using Access 2007. I have an unbound textbox (=ShowPersonnel) on the main form that is supposed to retrieve the information. What is wrong? I get the message Error#.The function . . .Public Function ShowPersonnel() As StringDim rst As DAO.RecordsetDim strText As String Set rst = Me!subfrmProjectPersonnel.Form.RecordsetClone If rst.RecordCount > 0 Then rst.MoveFirst Do While rst.EOF = False If strText <> "" Then strText = strText & "," End If strText = strText & rst!PersonnelName rst.MoveNext Loop End If Set rst = Nothing ShowPersonnel = strTextEnd FunctionThanks.David
    page tag? Display Record Number In Query UtfBUHJvcGzYWwgRGjdGy
• Access Query - Union Of Text Files That Are Selected.
  • Hi,I was wondering if this can be done.I will place the link name of delimited text file in a table1 in filedname like "c:\abc\test1.txt", "c:\abc\test2.txt", "c:\abc\test3.txt"and so on.The delimiting character is "|".The next column is Select yes/no in which I have option to tick thefile that I want to select.Now I want a query to include the file/files that I select in table1.It can be single file or multiple file.Since the text files change frequently, I wish not to import them orlink them.Instead I want to have a selection query of my choice.I hope I have explained it neatly.Looking forward for a solution.
    page tag? Display Record Number In Query Sinner
• Vc Recebeu Meu Msn
  • 
    page tag? Display Record Number In Query ezequiel
• Leading Zeros
  • I use Access as a database for my library. One of the columns is for the ISBN number. When these begin with a zero Access removes it/them. So far I have got around this problem by using 0. before entering the number.In Excel this can be got around by formatting the column as text but this option does not seem to be present in Access.Has anyone used a better way of combating this issue in Access?-- Alan
    page tag? Display Record Number In Query Alan
• Adding To Dropdown List
  • I am using Access 2003It has been quite some time since I have made changes to a database andforgot how to enter new selections.I have a database for restaurants. One of my dropdown boxes allows me toselect Type Food, such as American, Italian, etc.I want to add other ethnic food types and forgot how to do this.Could someone please give me instructions to add additional food types to mydropdown list.Please make it simple as it is difficult for me to follow very technicalexplanations.-- Thank you in advance for your support and suggestions,HankL
    page tag? Display Record Number In Query HankL
• The Itouch
  • Hi,I was wondering if they still make iTouchs? because my iTouch's charger won't charge. I'm thinking of getting a new iTouch. but I really need the charger.
    page tag? Display Record Number In Query Kiyoki
• How Do I Find My Database So I Can Print?
  • My assignment has me create a table, crate a form, then it says: Go to the Database view and print your database. Note that you ahould alter the column widths and make it a landscape layout so that it all fits on one page. I can't even find the database view!
    page tag? Display Record Number In Query UtfBTWljaGVsbGUgVHJpcGVueQ
• Select Query W. Dlookup => 2 Secs., Make-Table Version => 2 Hrs.
  • Dear all,I have created a database with 35.000 records. In this database, I have created a query that uses the DLookup function to retrieve data. In "select" mode, this query takes about two seconds to finish. In "make-table" mode however, it takes two hours. Access seems to freeze ("Not responding"), but remains active as the database file size continually grows until query finishes in the end.Normally I use Access 2003, but to test this I have also tried Access 2007, again with the same result.The field I use for DLookup is indexed.Does somebody know more about the possible cause?Thanks,Gerwin RamakerNijmegen, NL
    page tag? Display Record Number In Query UtfBRVydluIFJhbWFrZXI
• Access 2007 Error Message
  • Hi,Have just upgraded to ACCESS 2007 and saved my access2000 program into accesss 2007 format. When I run it, on my machine using VISTA and access2007 and using the system.mdw workgroup, it runs fine in .accde format.However, when I send it to my Boss to run on his machine, also using ACSESS 2007 and Vista, it gives the following error, although there is only one user active, and only one access db active at the time."The expression on click you entered as the event property setting produced the following error:The Microsoft Office Access database engine stopped the process because you and another user are attempting to change the same data at the same time"Any Ideas, anyone?Thanks in advanceHugh
    page tag? Display Record Number In Query hugh welford
• Dsum
  • see below data:Field Worker Job # Workdate Vacation Time (hours) VH TotVacTak CAGNEY, KEVIN 90180056 9/28/2009 0 12 CAGNEY, KEVIN 90180056 9/29/2009 0 12 CAGNEY, KEVIN 90180056 9/30/2009 0 12 CAGNEY, KEVIN 90180056 10/1/2009 8 12 8 CAGNEY, KEVIN 90180056 10/2/2009 4 12 the 1st column of VH(vacation taken) shows the acutal date the vacation taken. the second column is the DSUM- formula - text box (passed back in based off the the dsum by man name and date within 2009) the total is correct - BUT DO NOT LIKE that the dates prior to it taken(9/28-9/30/09) show up as having used 12 hours of vacaction - anyway to add code in to it show a Running Actual total - Thanks sooo much for helping! Barb "Frank H" wrote:
    page tag? Display Record Number In Query UtfBYmFicw
• Table Attribute = Hidden
  • Hi,I am using Access 2007.I have about 20 tables. I want to change the attribute of these tables to hidden.(right click on the table, then goto property, then make a checkmark in front of the Hidden box.)Is there a way to do this once without having to go into each of every 20 tables?Thanks,Boon
    page tag? Display Record Number In Query Boon
• Minimize Form And Minimize Access
  • Hi,Here is what I want it to happen --> When a user click minimize the form, I want the Access application to minimize as well.I put the Event procedure on the On Resize event of the form and put this code in.Private Sub Form_Resize()'Check if the form is minimizedIf Me.WindowHeight <= 1000 Then' the form has been minimized, insert your code hereDoCmd.RunCommand acCmdAppMinimizeEnd IfEnd SubIt did not work! Can you help me out? Is there a better way to do it?Thanks,Boon
    page tag? Display Record Number In Query Boon
• Date() And Access 2007 Runtime
  • I have an application front end which was written in Access 2002 but seemed to work OK in 2007 Runtime simulation so decided to convert to 2007 and then to install Runtime 2007 for those users without Office 2007 and have them run the application under that (XP OS). Conversion OK, and application works fine under full Access 2007, but under 2007 Runtime errors occur where Date() is used either as part of a query or default value for field on a form. Am experimenting by using Now() instead (which appears to be more reliable) but wonder if anyone has any other ideas as this is quite tedious since this is a large application.
    page tag? Display Record Number In Query UtfBUmzZSBC
• Query In Excel
  • Hi,I have list of list of around 5000 companies, but in that, companies are repeated. How do I delete the repeated companies?Sorting will not work in this.Regards,Ashwini
    page tag? Display Record Number In Query UtfBQXNodluaQ
• Sometimes Gotfocus Event Doesnt Occur On Subform...Strange
  • I have a mainform and a subform (named Lookup_results). The subform is bound to a query. There is a lookup button on the mainform with code DoCmd.Requery "Lookup_results" followed by Me.Lookup_Results.SetFocus to populate the text boxes on the subform. I want to have a msgbox appear when the query returns no data. To do this I put this code in the GotFocus event of the subform: If Me.RecordsetClone.RecordCount = 0 Then MsgBox.... I have not set focus to any of the controls on the subform. So far everything works correctly....until I added another text box to the subform. Now the GotFocus event on the subform doesn't occur when there's no data. If I remove the newly added text box then everything works correctly again. Why not? I need to add the textbox to the subform.Thanks in advance, Joe M.
    page tag? Display Record Number In Query UtfBSmlIEu
• Tout Telecharge
  • t
    page tag? Display Record Number In Query fabien carpignano
• Prova
  • ciao ciao!
    page tag? Display Record Number In Query Torelli Tatiana
• Linking A Table In Access With 365 Data Fields
  • I am trying to link an ODBC database table that contains 365 data fields and only the first 255 fields appear after the table is linked in Access. Does anyone know why the last 101 fields are not linking into Access? Is there anyway to get these fields to link in?Thanks,Mike
    page tag? Display Record Number In Query UtfBbWJsYWtl
• Tony Toews Auto Fe Updater V1.79
  • When locking out users shouldn't the "Open Server Folder" button be disabled? Currently when the database is locked the user can still open the FEnd on the server if they click on the "Open Server Folder" and proceed to launch the server mdb from the explorer window. Here is my INI file[Settings]MainApp=%appdata%\PrintShopTicket\PrintShopTicket_FEnd.mdbServer=\\Mhsoapp02\SHRCAOCom\ACCOUNT\OMaldo\MHS Print Shop Job Ticket\StartMethod=FileExtensionWindowStyle=MaximizedFocusLockout=YesLockoutMsg=Sorry, not allowed into the system right now.SupportMsg=Please contact your computer department for support.ShortcutErrorMessageHandling=2ShortCutName=PrintShopTicket_FEndCreateShortCutOnDesktop=yesShortCutIconFile=\\Mhsoapp02\SHRCAOCom\ACCOUNT\OMaldo\MHS Print Shop Job Ticket\ArchiveBackup\MSAccess.icoShortCutIconFileIndex=0
    page tag? Display Record Number In Query UtfBTWFsZG
• Import *.Qif File Into Access
  • Does anyone know how can I import a qif file (old Quicken format for bank statements, which is the one still used from my online bank) into an MS Access table?I have some knowledge of VBA, so I believe I could write the code to get it done but I imagine something already exits. (Althought Goggleing it gave no results).Thanks in advance.Alberto
    page tag? Display Record Number In Query Alberto Comino
• Print A Selected Sum
  • Each player earns points for victories (ptsearned). I would like to print on a report only those players who have earned 5 or more points? Using Access 2007.Carter
    page tag? Display Record Number In Query UtfBYFydGVy
• Auto Number In Query Design
  • Hi, I am using a query to create a data table, in the query, i would like to add a new autonumber column (just autonumber the row), is there a function I can do this easily?-- Thanks a lot!
    page tag? Display Record Number In Query UtfBSVaW
• Help With Date Difference Expression
  • Good morning,Based on the following:Lost Days = DateDiff("d",Nz([MyLostDaysBeginDate]),Nz([MyLostDaysEndDate]))Restricted Days = DateDiff("d",Nz([MyRestrictedDaysBeginDate]),Nz([MyRestrictedDaysEndDate]))I need an expression that will subtract the Lost Days from the Restricted Days, when the Lost Days date range is the same (or between) as the Restricted Days date range. This will yield total Restricted Days.Example:Restricted Days were incurred from 02/01/09 to 03/01/09 and Lost Days were incurred from 01/01/09 to 02/15/09. The overlap occurs from 02/01/09 to 02/15/09.How can arrive at the Total Restricted Days?Thanks in advance for your help,Rene
    page tag? Display Record Number In Query UtfBUmVuZQ
• Force The Users To Enter Value In A Text Box Based On A Combo Box
  • Hi,I have a form which the combo box control that has (0 & 1) and text box assocaited for the combo box; my question is that; if users select 0 value from the combo box; then they should be forced to enter some value in the Text box; currently I have the code at two places as below: but for some reason; I am not able to force the cursor not to go to the next control....and should pop-up with the message until some value is entered in the Text box ....Private Sub cboTD_AfterUpdate()If cboTD = "0" And (txtTS_Note = "" Or IsNull(txtTS_Note)) Then txtTS_Note.SetFocus txtTS_Note.BackColor = vbRed Else If (cboTD = "1" Or cboTD = "N/A") And (txtTS_Note = "" Or IsNull(txtTS_Note)) Then txtTS_Note.BackColor = vbWhite End IfEnd IfEnd SubPrivate Sub txtTS_Note_LostFocus()If cboTD = "0" And (txtTS_Note = "" Or IsNull(txtTS_Note)) Then txtTS_Note.BackColor = vbRed MsgBox ("Please enter a value for the TS Notes field") Me.txtTS_Note.SetFocus Exit Sub End IfEnd Sub
    page tag? Display Record Number In Query UtfBTko
• Concatenation On Two Fields
  • I have two text fields that I want to automatically concatenate together to create a third text field. For example, text field 1 is a list of values such as T1039, S0297, S0416, S2274. Text field 2 is a user input value with an R concatenated on to the front of it. So, user might enter 001, but the value needs to be stored as R001. But, then I need a Text Field 3 to store the two inputs as TextField1&TextField2, i.e. T1039R014?
    page tag? Display Record Number In Query UtfBSVubnlE