Hyperlink In Query Field

Recent Posts

• Email Several Reports Using Do Loop And Recordset
  • Can someone direct me on how to use a Recordset field in a Report I create in a VBA module and use as an attachment to a MS Outlook Message? Also is there a way to Email messages and attached reports without encountering (or bypassing) the Microsoft Outlook Security Feature? My Recordset is a Table of Suppliers and their E-mail Information (SupplierID, SupplierName, EmailPersonName, EmailAddress,EmailMessage). I would like to Loop through the records using some of the fields in the generation of the report. I have tried several methods to identify the recordset field in the report but to date have not the correct syntax. I appreciate any help. Thank You! -- frank-a
    page tag? Hyperlink In Query Field UtfBRlNITRU
• 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? Hyperlink In Query Field UtfBbxkamF
• Create Word Document From Scratch, From Access 2007 Data
  • I'm trying to create a word document based on some data in an Access database, and using some rather convoluted business logic. I don't want to have to field a document template with my application, so I would like to create this document from scratch, each time the user selects this option.I've figured out the processes for opening Word (with either GetObject or CreateObject), and creating a new document based on the normal template. What I need to know now is how to:1. Insert text into a blank document. I've found a couple of posts on how to place bookmarks, and paste text at the bookmarks, but this is not possible without sending the document template.2. Format text as bold/underline (Would like to turn this on and off prior to inserting some of the text), and then return the format to normal3. Change the font and fontsize (again, would like to be able to do this before inserting a block of text and turn it off at the end of the block)4. Keep track of what line I am on in the document5. insert a page breakAny help would be greatly appreciated.----Dale
    page tag? Hyperlink In Query Field UtfBRGFsZSBGeWU
• 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? Hyperlink In Query Field UtfBaRkaWQ
• Can'T Open Excel; Get Error Msg Citing Problem In Shortcut. No Pro
  • -- CNTGDthisthatandtheother
    page tag? Hyperlink In Query Field UtfBSSDbGFZDk
• 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? Hyperlink In Query Field UtfBTWVnYXRvbg
• Select Range From Column Values
  • I have a long list of names and associated info in rows with embedded dept names and would like to break this out by dept... either as a page break or named range, so I can print out each dept separately. Looks kindof like this:A B CFinance Deptbob... ssn IDsally... ssn IDfred... ssn ID10 more names...Marketing DeptJoe...Lou...3 more names...Contracts DeptJenny...Alice...Next Dept...thx
    page tag? Hyperlink In Query Field UtfBTWFhcmty
• Automatically Get Value From A Table Based On Values Entered On Fo
  • I have 4 fields on a form: [Activityname], [Itemname], [UOM], and[Equipmentname]. I would like to create a text or combo box that based onwhat the user enters in those 4 fields, automatically populates a field froma separate table called [tblgoalbyequipment].[goallevel]. I see numerous postson here that would seem to answer the question, but not having much luck.Thanks!
    page tag? Hyperlink In Query Field UtfBUFBDTw
• Convert Data From Unnormalized Table
  • When I first started using Access and had no understanding of normalization I made a database for scientific data whose data table contained fields for SampleID, DataID, and one each experiment we conducted and we put data in it. This table contained over 100 fields. I later realized my error and made a new database whose data table contains the following fields: SampleID, DataID, Property, Method, Numeric Results, TextResults, and Units. Is there a way I can get the from the old table into the format of the new table with out manually retyping all of it? I'd like the field names to go into the Property field and any value in the table to go into the results field. One record from the old table would have between 1 and 10 records in the new table. It would be alot less work to fix the records from that point and produce fewer typing errors. Thanks. Marcie
    page tag? Hyperlink In Query Field UtfBYnltYXJjZQ
• Contact Management Database Problem
  • I have installed the "Contact Mangement" Database. The problem I am having is when I open the Contact Details Form in the design view and then Insert a new page, two items show through from the first page. The Address Label and the + - Images label. I loaded this from the Access 2007 featured on line templates. I just can't seem to figure out how to have them not show on that second page, or second tab. Oh, Also, if I copy the contacts data group (Name, address etc..) and past it on the second page they show through to the first page with a slight alignment issue it really show up. Please help.Michael
    page tag? Hyperlink In Query Field UtfBTWlrZVNy
• 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? Hyperlink In Query Field 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? Hyperlink In Query Field M Skabialka
• Code A Button To Display Line Items Of Table That Appear More Then
  • Hello,I have a table (Main_table) that has 3 columns. The three columns are Part, Name, and Location. I also have a form that has 3 list boxes (lstPart, lstName, and lstLocation), and a button. I would like the user to click the button and the list boxs would populate with all items that appear more than 15 times in the table. lstPart would show all of the line items that appear 15 or more times in the category.I am a little confused on how to code this. Can someone provide assistance?
    page tag? Hyperlink In Query Field UtfBQlpleWdlcg
• 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? Hyperlink In Query Field UtfBbWlrZWFyZWxsaQ
• Sofia Talentos ( Procura Talentos )
  • ATENÇÃO: EU MARIA SOFIA FILHA DE JOSE PRAXEDES ESTOU FAZENDO UM SHOW DE TALENTOS OBRIGADA PELA A ATENÇÃO
    page tag? Hyperlink In Query Field isoQJosEPraxedes
• Experimenting With News Groups
  • No need to reply - just testing with New Groups
    page tag? Hyperlink In Query Field Chelsea
• Field Types
  • Hi allI am creating a search form, I have populated a combo box in the header with the row source based on Field list from a query (aliases of real field names). How can I add an extra column to this containing each fields data types, so I can use this somehow in a filter in vba? I have a lot of fields so I want to be able to use one text box as search criteria which can be used to enter text, number or a date etc.Thanks in advance for any help.
    page tag? Hyperlink In Query Field UtfBaHVnaGVzczc
• Code For Message Box
  • This is a pretty simple question but can someone show me the VB code for a cancel button. I alredy have it as far as showing the message box when you click cancel thats says "are you sure?" and it has yes or no as an option. I need the code that closes both forms if yes, and closes the message box if no.-- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".
    page tag? Hyperlink In Query Field UtfBTkFT
• 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? Hyperlink In Query Field UtfBVFyRWFnbGVEYW
• Outlook Email Content Linked To Ms Access
  • I can link an outlook folder to a table in Access, I get all the fieldand most of the data in the fields but the messege content (body txt)does not show. The fields are there in the table just empty. What am idoing wrong.
    page tag? Hyperlink In Query Field John Nipper
• 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? Hyperlink In Query Field George
• Change Data From 19860701 (Text) To 07/01/1986 (Date)
  • I am working with a table that has DOB dates in a text field and stores data in this format 19860701... i tried changing the data type of the field (in table design window) but it tells me that i don't have enough memory to change it...is there any other way i can convert this data into date format? I sort of need to validate it against Date()
    page tag? Hyperlink In Query Field UtfBQWdlbnRfSdC
• Storing Images In Access
  • I've read lots of posts recommending not to store images in an Access database, and I usually just store pointers to the images. However, I'm trying to figure out whether it is possible to store the images in the db and extract them from the db at runtime.Specifically, I am working on an application which, among other things, creates several different PowerPoint slides (this is working pretty well so far). Now, I have to figure out a way to put these images in the upper left and right corners of the document, without deploying a .ppt template. So, the first step is to figure out how to store and retrieve these images.I also use these images in multiple Access reports and forms, so storing the image and then filling (somehow) the Access report and form image controls when these forms or reports are loaded would significantly reduce the size of my Access application.Is this a stupid idea? If not, what are my options?----Dale
    page tag? Hyperlink In Query Field UtfBRGFsZSBGeWU
• How To Capture Text Form As A Default Value
  • I am trying to find a way to capture text in a field on my form to be the default value for a field in a record. Does anyone know how to do this in Access 2003?
    page tag? Hyperlink In Query Field UtfBZVvcmdlbYgdGhlIGpbmdsZQ
• 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? Hyperlink In Query Field UtfBQmlsbGlhbQ
• Access Database Deleting
  • how to remove the first word "only" in a cell. example: and also who ever sends me an e-mail is my friends so send. I would like to remove the first word "and". the other issue is that not all the cells begin with the same word. Is this possible to do. I am new to this so i could use the help
    page tag? Hyperlink In Query Field UtfBamVYW
• Help Me
  • im new to htis and i will not let me send a message to anything can someone pleas help me
    page tag? Hyperlink In Query Field zack russell
• Filter Query
  • I have a query that contains SSN's. The SSN's contain 10 characters, the first being a designator for branch of service or civilian. For example, SSN's beginning with "0" belong to Marines, while SSN's starting with "N" are Navy. What I need to do is filter out all Navy and Civilian personnel and show only Marines. I have tried what I thought would work in the criteria row but nothing is working. Please advise. Thank you.-- NO, I DO NOT WANT YOU TO BUILD A DATABASE FOR ME FOR A "REASONABLE FEE".
    page tag? Hyperlink In Query Field UtfBTkFT
• If And Vlookup Statments Together
  • ={IF(K8=AA11:AA21,VLOOKUP(K8,'Regular Assessment Table'!I2:J12,2,FALSE))}The above formula is looking up a K8 text content and returning avlookup value from a table. Part of the text I enter is "104(a)Citation" and the formula return the correct value. But when I enter"104(d)(1) Citation" the formula returns FALSE. For the life of me Icannot determine why this is happening. Any ideas?
    page tag? Hyperlink In Query Field Don B
• Setting Focus After Error
  • If they try to enter a record without a selection in the parent form I need to return them to the main form - I have tried different ways but none work - this is my current tryPrivate Sub ModelName_Enter() Dim StrName As String Dim i As Integer Dim Msg As String StrName = Nz(Me.Parent![VehName]) If StrName = "" Then GoTo 100 GoTo 200100 Msg = "'" & "' No Vehicle Name is Selected." Msg = Msg & " - Select Vehicle Name" i = MsgBox(Msg, vbQuestion + vbYesonly, "Unknown Vehicle...") Response = acDataErrContinue Forms!vehicle!VehName.SetFocus200 Exit SubEnd SubWhen it returns it goes to the field ON THE SUBFORM that it started in - not the parent form
    page tag? Hyperlink In Query Field UtfBTnlsZXg
• Regular Expressions
  • I've just started seriously messing around with reg exps in Access VBA and predictably, am opening all kinds of worm cans. Is there a difference between the following?Dim RE as RegExpSet RE = New RegExpandDim RE as ObjectSet RE = CreateObject("VBScript.Regexp")Various uses give me differing error messages, but I've been unable to find any references to either in the online help, and googling around the net hasn't shed any light on this particular topic.Pete-- This e-mail address is fake, to keep spammers and their address harvesters out of my hair. If you want to get in touch personally, I am 'pdanes' and I use yahoo mail. But please use the newsgroup when possible, so that all may benefit from the exchange of ideas.
    page tag? Hyperlink In Query Field Petr Danes
• Add-Ins Won'T Load At All In Access 2003
  • I previously used Access 2003 almost everyday until I switched jobs. So its been a year and I went to create a new query in an existing database and the normal query wizards weren't there. I went to Tools, Add-ins, Add-in Manager and the add-in manager is blank. I go about adding in the normal add-ins I click Close and nothing happens.I go back into the Add-in Manager and its blank again.It won't load them. Anybody have a problem like this... does anybody know how to resolve it? Thank you in advance for any help you could provide.
    page tag? Hyperlink In Query Field UtfBURldmU
• Field/Column Limit
  • Dear,My query will produce a table of 2,000 Fields and 10,000 rows. Is there any way to extend field/column limitation in Acess? Thanks,Pemt
    page tag? Hyperlink In Query Field UtfBcGVtdA
• Karen Shultz
  • hey karen how r u doing i just wanted to say hey and DOYOUWANTTOBEMYFRIEND?
    page tag? Hyperlink In Query Field T
• Task Bar
  • Suddenly my task bar appear vertically on the right of my desktop. How can i change it ?
    page tag? Hyperlink In Query Field UtfBUGllcnJl
• 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? Hyperlink In Query Field 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? Hyperlink In Query Field 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? Hyperlink In Query Field Milhouse Van Houten
• What
  • What!
    page tag? Hyperlink In Query Field tom
• Find Record On The Many Side
  • Hi Guys,I have a Form with a 1 to many relationship between 2 tables with ref. integrity enforced. I need to find records stored on the many sided table. Anyone point me to KB or other tutorial that doe this?TIAjohnb
    page tag? Hyperlink In Query Field UtfBamobmI
• Help W Conditional Formatting In Vba
  • I am trying to apply conditional formatting. i have to use codesincei have 10 different conditions. basically, i want to change thecolorof the font color and backgroud color of a text box (txtRoleName)based on the value.I tried writing an If statement on the details part of the form, butican't seem to get it to work. I cant find a value that works. Itried using *ctrl *space after i type in my texbox anme, but cantfindanything that seems like it would work from the drop down thatappears. Here is the logic i would like to follow:If txtRoleName.Value = "Student" ThentxtRoleName.FontColor = vbRedtxtRoleName.ForeColor = vbGreenElseIF txtRoleName.Value = "Faculty" ThentxtRoleName.FontColor = vbGreentxtRoleName.ForeColor = vbRed
    page tag? Hyperlink In Query Field Gaby Sandoval
• Xccxcx
  • 
    page tag? Hyperlink In Query Field george
• System Files Need Updating????
  • Hi, I have an Access program that I package with Access runtime using office developer 2000. I sell this program to raise money for St. Judes Hospital and have very few install problems. I currently have a user that when he runs the setup program he gets an error stating that some system files need to be updated. He then gets an option to update the files and if he clicks yes something happens and then he get a message that setup needs to be run again. When he runs setup again he gets the same system file needs update message. He is running XP Pro.Any help would be appreciated.Thanks,Phil-- Phil
    page tag? Hyperlink In Query Field UtfBUGhpbA
• How To Open Pdf From Vba
  • Hi All,I am doing a task with pdf files and got some questions:1. How to print pdf file by using VBA code without open it? I mean doit in the back end and user does not see it. I have tried some codebut not working. Can anyone please give me some example?2. I have got two pages in a pdf, but I want to print it into onepage. (I have got large printer.) Is it possible to do it in the code?Thanks in advance!CheersDanel
    page tag? Hyperlink In Query Field daniel
• Opencurrentdatabase In Second Instance Of Access Does Not Throw Error If It Failes
  • Access 2007I have code that creates a second instance of Access and uses it to open another database as itsCurrentDB: Set mappAccess = New Access.Application mappAccess.OpenCurrentDatabase strPathDBName, False, strPasswordIf the OpenCurrenDatabase method fails (i.e. the strMDBPath is locked because it is already openedin exclusive mode) it does not throw an error. It just doesn't open the database.If I open Access and manually try to open a database that is locked Access throws an error saying itcan't open it.Why doesn't the OpenCurrentDatabase method throw an error? Is this by design?
    page tag? Hyperlink In Query Field Stewart Berman
• Memo Field - Allow User To Insert Hard Return (Enter)
  • On a memo field, is it possible to allow the user to insert a hard return, by hitting the enter key, to leave space between paragraphs within the memo field?
    page tag? Hyperlink In Query Field UtfBUJlYtlcg
• 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? Hyperlink In Query Field Eric D Braden
• Hohj
  • 
    page tag? Hyperlink In Query Field marti misselis
• Hello
  • How are you everybody
    page tag? Hyperlink In Query Field Roque Silva Morgado
• Color Report Textbox
  • Color Report textboxHello,Using Access =9203=85I=92m trying to build a report with a little color=85I have a key that I keep in the Page Footer of the Report. It=92spretty simple and looks like this:1 to 5 =3D poor5.1 to 10 =3D fair10.1 to 15 =3D averageEtc=85I use colors to delineate the various ratings; e.g., poor is blue,fair is yellow, etc., up to 6 ratings.In the detail section of the Report are two textboxes that calculate aperson=92s rating (number and text=85e.g., 8 fair) by month. I=92d like tocolor the textbox(s) based on the key=85I cannot use conditional formatting because I have more than 4 colors=85I=92ve tried this code in the On Print Event:If [ControlName] =3D =93pick value=94 thenMe.ControlName.BackColor =3D pick colorEnd ifIt will color the textbox, but the textbox won=92t requery when itsvalue changes=85remember the report is by month and several months arereported at a time!My options seem to be limited; not sure if someone has some insight.Thanksalex
    page tag? Hyperlink In Query Field alex
• Copy Or Duplicate Record Woes
  • Hi EverybodyAccess 2007I have a form based on a query that does NOTinclude the primary key autonumberAnd I am trying to use the "Duplicate" commandYet I get the error that this new record has created"duplicate Values in the Index, Primary Key, or Relationship"Is there any other way to copy a record?Thanks
    page tag? Hyperlink In Query Field bobdydd
• Confimation
  • again tis is to confirm connection
    page tag? Hyperlink In Query Field Roy Eaton
• 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? Hyperlink In Query Field mrwawa
• Sort In Query
  • I have problem to sort below field in my query.([fstrlsedt]-date fieldRelMthYr: Format([fstrlsedt],"mmm-yyyy")I expect to get Jan-2009,Feb-2009 & so on...but turned out to be Apr-2009,Aug-2009,Jul-2009....Thanks
    page tag? Hyperlink In Query Field UtfBenlcw
• Web Enable?
  • Can I web enable an access database on an intranet? specifically The frontend (data entry ) and report generating functionality? YES or NO?
    page tag? Hyperlink In Query Field UtfBQhpcnM
• Time Sheet Design Help
  • I am trying to design a database timesheet/clock for a department that needs to track daily time in, lunch out, lunch in, daily time out.I don't want the associates to be able to manipulate the time in any way and started with using the date/time stamp from the system but with that field, I'm not finding that I'm able to calculate the hours worked for an employee as I'm creating 4 records for that day and I'd like to somehow create one record for the employee for a given day.They basically need to be able to go and 'punch in' and 'out' when the time comes and have that time 'stamped' from the system and not manually put it in themselves.Is there a way to set this up so that the employee can enter their time in/out or have 4 entries for one day or even just two if no lunch, and have that time 'stamped', like a "Now()" so that they not enter the time (honesty issues) AND be able to calculate the hours worked in a report? I don't want any times to change or update upon entering the record again.Thank you so much!Harriet White
    page tag? Hyperlink In Query Field UtfBSGFycmlldA
• Multiple "And" In Where Clause
  • I have a table with 2+9 fields.I want to display rows for if [field3] and [field4] and [field5] and [field6] and [field7] and [field8] is not blank.I am trying this using Where Clause but it's not working.I triedWhere (field3 is not null) and (field4 is not null) and (field5 is not null) and so and so...Please help.Thanks
    page tag? Hyperlink In Query Field UtfBaF
• Access 2007 Vba Code To Launch Label Wizard
  • Does anyone know the vba code to lauch the label wizard in Microsoft Access 2007. And yes I need it as vba code. On the ribbon it is as follows - Create Tab | Reports | Labels (Create Labels)Help with this would be sincerely appreciated!
    page tag? Hyperlink In Query Field UtfBZGFYWNzdHI
• 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? Hyperlink In Query Field Duncs
• Link To Xls Or Import Dbf
  • I posted this in Import/ Export ..no replies yet. Looking to see if someone reading here might know the solution...A snippet (see below) of an Excel file that I tried Access linking to Excel...the Color "3R3" below links in Excel as #Num! (a dealbreaker).If I save as a DBaseIV, any Color NOT readable as a number arrives as a Blank.Also, saving as a DBF changes all the "GoPK" below to a Date..IE 9/10/09. I can deal w/ that in the VBA code I use working w/ the DBF. I had hoped to either bring in a GoPk (IE...9/10/09 6:49:09 AM) as a Date (w/time), or use as a PK (as a text)..which would be unique combined w/ Booth as a multi-key PK. Is there a known "negative" using a longer text (IE...9/10/09 6:49:09 AM) as part of a PK?I could also deal w/ this data w/o using a PK.The ISSUE now...getting all Color values in the DBF when they appear as a number (IE..202), or a text (IE...3R3). TIA - BobGoPk Booth Acolor9/10/09 6:49:09 AM C 2029/10/09 6:53:33 AM D 2029/10/09 7:55:44 AM D 3R39/10/09 8:12:30 AM C 202
    page tag? Hyperlink In Query Field UtfBQmiIEJhcmlcw
• 123456
  • jopieuret
    page tag? Hyperlink In Query Field sdsd
• Gklds
  • liusenlin
    page tag? Hyperlink In Query Field tom
• Hehe
  • 
    page tag? Hyperlink In Query Field ms
• 11111
  • 22222
    page tag? Hyperlink In Query Field princess
• Kjfg
  • GFJKDFG
    page tag? Hyperlink In Query Field happylulu
• Msnew
  • 
    page tag? Hyperlink In Query Field miss zhang
• 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? Hyperlink In Query Field UtfBTkFT
• 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? Hyperlink In Query Field UtfBUHJvcGzYWwgRGjdGy
• Appending To A Combobox
  • I was wondering if I can have a ComboBox populated by a query but always have the words of 'Select A Name' showing when the form loads. That way, I could check to see if the value is 'Select A Name' to populate a message stating 'please select a valid name.Thanks for your assistance.
    page tag? Hyperlink In Query Field UtfBQnVuak
• All Commands Not Working
  • Hi. A few months ago I posted<<I've designed a database that's been great and all well.A few days ago, I made some adjustments and added new stuff. Very happy andit worked fineOpened today and it opens ok but not a single command button works. There isno error message or VB debugging either. just nothing.<<The reply I got wasst3a4r5tb1logi5xo6nge6n8d9b0l0ockMS Access 2003 and 2007 have a feature (??) that can disable all code ifthere is not a proper certificate for the app or it is not stored in a"safe" location. Your problem is definitely related to this. To prove/disprove do this to your self, close your app; go to Tools\Macro\Securityand set the level to "Low"; reopen your app. Bet the code runs again.'''''''''I carried this out and it didn't work. So I created a new file and imported everything over which was a long process.Now it's happened again with another file. This time it happened while using it and adding a new form. Suddenly no commands work in any part. All objects open but commands within them do nothing. .I tried a couple of other databases and they are fine.I compacted and repaired but still nothing.Any help will be very grateful.(MSAccess 02 sp3)JenRegards
    page tag? Hyperlink In Query Field JB
• Counting Specific Characters Within A Field
  • OS: Windows XPApp: Access XPI have a field with over 100 characters of data. I want to count the number of Tildes (~) found within the field and their position.I want to extract text strings positioned between each occurrence of each Tilde.Any help would be appreciated.Kind RegardsMike
    page tag? Hyperlink In Query Field UtfBTWlrZSBGYXVsalcg
• Hifi
  • 
    page tag? Hyperlink In Query Field francis monville
• 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? Hyperlink In Query Field 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? Hyperlink In Query Field UtfBTWljaGVsbGUgVHJpcGVueQ
• Hola
  • 
    page tag? Hyperlink In Query Field jimenita
• Select From Choice Of Tables
  • Hi,I'm trying to set up an append query to select/append data from a whichever table has been specified in a box on a form.The column/field names will be identical in all these tables, so it's just definig the table name in the From section of the SQL. Is there a bit of code to do this?Thanksmerry_fay
    page tag? Hyperlink In Query Field UtfBbWVycnlfZmF
• Current Average Problem
  • I have a database with two tables of relevance to the current problem. One is a record of WORK TITLES, with a PK autonumber field. The second contains a list of STUDENT WORK, which are populated with a studentId, and workId from the first table. I have created a query linking the two tables, and a form in which I can enter marks for each student. What I seem to have trouble doing is getting the form to put the current value of the average for the piece of work into the WORK TITLES table (a field showing in the form). I have played around with the field in which I enter the actual marks, and set the on Change property to DAvg("[Percentage]","ReviewPieceOfWork-Q","[ID]= [ID1] and [Percentage]<>0") where [ID] is the autonumber value, and ID1 is the alias of the field on the form (in other words, it calculates the average only for that piece of work). However, it seems to give me the value it was before the last change. If I put a local unbound field onto the form with the same syntax, it returns a different (correct) value. I have even tried changing the value to that of the unbound field but to no avail.Any ideas?
    page tag? Hyperlink In Query Field UtfBRGFZSBSZWFyZGu
• Hallo
  • Hy Reni,Hoffe dir geht es gut. Habe mir gedacht wenn ich am Computer sitze schreib ich dir mal per E-Mail und nicht per SMS. Mir gehts gut . . . Außer ein paar Kopf schmerzen . Aber das íst die Wetterumstellung bei uns. . Hatten schon unseren ersten Schnee. . Daraufhin habe ich mir neue Winterreifen besorgt. Und der Oberhammer ost ja der das sie mir irgendwann im September meine Felgen für den Reifen gestohlen haben. So habe ich mir Felgen auch besorgen müssen. Bei der arbeit geht es locker dahin. . Kommen mit der Produktion nicht nach und wir beim montieren sind zu schnell . Hat natürlich auch seine guten Zeiten. So brauche ich nicht mehr so lange arbeite. So bald ist es soweit und Karin und ich sind ein Jahr zusammen. . Ist ein Wunder. . . Hatten es nicht immer leicht. . Gab Höhen und Tiefen. . Aber wir haben sie alle überstanden. . Muss mir überlegen was ich ihr schenken werde. . So nun wünsche ich dir eine gute nacht,wede mich nun auch zu bett begeben. . muss morgen wieder früh raus. . Eine angenehme Woche!!!!GrußPatrick
    page tag? Hyperlink In Query Field Patrick Woger
• Dlookup Save To Table
  • I am helping the owner of a table who inherited a database that needs to be re-disigned in the future. For now, she has a form where the user selects the employee name from a drop-down list. (The values are from a separate table.) When the name is displayed, a separate field displays the associated employee number (dlookup is used to display the number). The employee name is saved to a table but they also want to save the employee number. (I know this isn't good database design, but it isn't my db.) What is the best way to save the emp number that is populated using the dlookup?-- Thanks!Chris
    page tag? Hyperlink In Query Field UtfBQhyaXM
• Class
  • HelloI want to dropyou class buti dont how to doand want to ask youif you can help mepleaseThanksAdriana Gaona
    page tag? Hyperlink In Query Field Adriana
• Protect Data Once Entered Into Field
  • I have a database with loan numbers and issues/incidents associated with the loans. Is there a way to lock the information, once it's been entered? I've already had a couple of loan numbers deleted by other users in my department. I'd like to maybe create a pop up that questions whether the user really wants to do what they are trying, which would be any time someone tries to edit information already entered in the field. Suggestions?
    page tag? Hyperlink In Query Field UtfBUJlYtlcg
• Collect Data Via Email Question Length
  • I want to use the collect data via email functionality in access to gather simple answers to survey questions. My problem is that the survey questions are too lengthy (150 characters) and I can't get access to let me use the question as the field name in my table or as the label to display in front of the field in the email message.Is there a way to get around this (infopath is not an option)?Thanks
    page tag? Hyperlink In Query Field UtfBYndpbGsNw
• Faut Elle Aussi
  • je suis manque d ero alor que j ai prie d ero
    page tag? Hyperlink In Query Field fabien carpignano
• Prova
  • ciao ciao!
    page tag? Hyperlink In Query Field Torelli Tatiana
• Date Diff Using Criteria
  • I may be going about this all wrong, if so advice always appreciated.In the form and in the report I need to display the number of days elapsed - if the DateResolved is blank then the number of days between SubmittedDate and today and if the DateResolved is not blank then the number of days between SubmittedDate and DateResolvedI have been putting it in an unbound text box on the form and report. This is the formula I have been playing with, it only works halfway, it shows the number of days between Submission and Resolved, but not Submission and todays date=IIf([DateResolved]="",DateDiff("d",[SubmittedDate],Date()),DateDiff("d",[SubmittedDate],[DateResolved]))thanks in advance
    page tag? Hyperlink In Query Field UtfBQFNSSBMYWR
• Controlling Display Of The Access Menu Bar And Program
  • When I run my databases I would like to have the screen display only the forms in my database, not parts of the MS Access program or engine such as the menu bar at the top ("Home", "Create", etc.) and the "Quick Access Toolbar". Is there any way to configure the MS Access program so it does not display these components. When they appear it looks like the database is still being developed and is not a finished product. I have searched through all the literature, but can't find a solution.
    page tag? Hyperlink In Query Field UtfBUHJvZJhbURvYw
• How Do I Change Program From Read Only
  • I want to open my databases in a normal format to manipulate information can anyone assist me with opening program in a normal format?
    page tag? Hyperlink In Query Field UtfBVldN
• Looking For Real Estate Market Statistics Dashboard.
  • I want to start keeping a stats on my local market, and need a dashboard template.
    page tag? Hyperlink In Query Field UtfBSmoMzExNQ
• Word 2007 Is Locked And No Application Working .
  • i got HP laptop with 60 days trial version of office 2007 built in it.Its been 18 days and my Ms word has locked and i am not able to type any thing any thing into it.pls help.vikas2joshi@yahoo.co.inthanks
    page tag? Hyperlink In Query Field UtfBbGjaVkIHZpaFz
• 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? Hyperlink In Query Field UtfBSVaW
• How To Set Field From Vba On Form Save
  • Hello I have a data entry form with a label that displays a running timerhh:mm:ss.The value displayed on the timer label must be saved to the TimeSpentfield of the table when the form is saved.How can I set the TimeSpent field in the current unsaved record whenthe save button is clicked????.TimeSpent = TimerLabel.captionThanks
    page tag? Hyperlink In Query Field frank
• Combo Box Requering
  • This should be very simple but I cannot seem to get it to work. I have a form that has 2 combo boxes. The first one is the supervisor and the second is the specialist. I want the specialists to change when the supervisor is changed. I have read and re-read the postings that say to do a Me.Requery in the After Update event of the driving combo box (In this case - Supervisor). The supervisor combo box is driven by a query and the specialist combo box is driven by code on the Row Source. Since I am using both combo box values to feed other queries, I have moved each to textboxes.Supervisor is ComboBox 17 and the value goes to textbox 37Specialist is ComboBox and the value goes to textbox 52Everything works fine on the first supervisor chosen and I can change the specialist all day long with no problem. But when I chose a different supervisor, the specialist values do not update. Why? Ideas?
    page tag? Hyperlink In Query Field UtfBQnVuak
• Find Start And End Times
  • I have a web page form that Employees enter when they enter a Weld Booth and when they leave a Weld Booth. I need to get:Emp# Booth Stat Timestamp ID608 Booth10 INBooth 10/21/09 11:24 831608 Booth11 OutofBooth 10/21/09 11:23 830483 Booth08 OutofBooth 10/21/09 11:23 829608 Booth11 INBooth 10/21/09 7:51 828608 Booth12 OutofBooth 10/21/09 7:51 827608 Booth12 INBooth 10/21/09 7:50 826414 Booth05 INBooth 10/21/09 7:50 825483 Booth08 INBooth 10/21/09 7:50 824413 Booth13 INBooth 10/21/09 7:49 823300 Booth01 INBooth 10/21/09 7:49 822413 Booth09 OutofBooth 10/21/09 7:03 821483 Booth07 OutofBooth 10/21/09 7:02 820300 Booth04 OutofBooth 10/21/09 7:02 819300 Booth04 INBooth 10/21/09 6:58 818300 Booth01 OutofBooth 10/21/09 6:58 817413 Booth09 INBooth 10/21/09 6:58 816483 Booth07 INBooth 10/21/09 6:57 815300 Booth01 INBooth 10/21/09 6:57 814Into the format below using a query:Emp# Booth Start End300 Booth01 10/21/09 6:57 10/21/09 6:58300 Booth04 10/21/09 6:58 10/21/09 7:02300 Booth01 10/21/09 7:49 10/21/09 15:15483 Booth07 10/21/09 6:57 10/21/09 7:02413 Booth09 10/21/09 6:58 10/21/09 7:03413 Booth13 10/21/09 7:49 10/21/09 12:58413 Booth13 10/21/09 12:58 10/21/09 15:15483 Booth08 10/21/09 7:50 10/21/09 11:23483 Booth11 10/21/09 11:24 10/21/09 15:15414 Booth05 10/21/09 7:50 10/21/09 13:30414 Booth09 10/21/09 13:30 10/21/09 15:15608 Booth12 10/21/09 7:50 10/21/09 7:51608 Booth11 10/21/09 7:51 10/21/09 11:23608 Booth10 10/21/09 11:24 10/21/09 15:15597 Booth07 10/21/09 11:24 10/21/09 15:15Any ideas how I do this. I haven't worked with a date time and getting the ending times usually the databases I worked with have Start and End times in the same record.Thanks,Greg
    page tag? Hyperlink In Query Field UtfBZNdHRlcg
• Switchboard
  • I deleted the form switchboard but the switboard is still in the switchboard manager as the default. I cannot delete the default switchboard. How can I get a form back to use the switchboard or delete the default switchboard and start over?This is Access 2003 and I'm new at this.
    page tag? Hyperlink In Query Field UtfBYmcx
• Hidden Table?
  • HelloI am updating a ASP system (meaning that I did not create it nor knowmuch about MS Access), where there are some selects and other tableopertations, but I cannot see the tables or views (there are no viewsAFAIK)Under tables I have 8 table but none with the name in questionUnder queries there are also some items, but they all seem like beingused for testing.There is one module, but that seems to be empty.When I run a select from job and mounting, then I get data, also I canupdate it. But I cannot see the tables...Any ideas?WBRSonnich
    page tag? Hyperlink In Query Field jodleren