Write To A Memo Field

Recent Posts

• Access Form And Gif89
  • Hi,How to put access to work with Gif89.dll. I have oput the activeX on my form and cannot find a place where I can link the gif file.I have Access 2007SF
    page tag? Write To A Memo Field SF
• 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? Write To A Memo Field UtfBcFmaGlyZSBjYXJz
• 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? Write To A Memo 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? Write To A Memo 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? Write To A Memo Field UtfBYnltYXJjZQ
• 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? Write To A Memo Field UtfBSGFybxk
• 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? Write To A Memo 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? Write To A Memo Field UtfBSmVmZiBD
• Running Total On A Report
  • HiI have an inventory report by product showing qty received and qty shipped..useing 2 tables qty rec and qty shipped...I have the report grouped by product & rack...a product/rack may have multiple shipments against it..how do i code the report so that the receipt of the product/rack only accumaltes once, it now accumlates for each shipment against it...example prod 123 rack A has a qty rec of 12...it has 2 shipments one for 2 and another for 3 ...I want to show total rec qty of 12 and total ship qty of 5...what I am getting is a total rec of 24 Hope I am makeing this clearThanks
    page tag? Write To A Memo Field UtfBTWFyeQ
• 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? Write To A Memo 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? Write To A Memo Field UtfBbWlrZWFyZWxsaQ
• Import Excel Table Hyperlink To Acces 2003
  • I have an Excel table with about 3000 hyperlinks I tried importing to access, when i do the link dissapears, only text appear is there a way to import into access the ecel table and have the links working still
    page tag? Write To A Memo Field UtfBdmljdGyaWwNzA
• Experimenting With News Groups
  • No need to reply - just testing with New Groups
    page tag? Write To A Memo Field Chelsea
• 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? Write To A Memo Field mabeline
• 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? Write To A Memo Field UtfBaHVnaGVzczc
• Open Existing Database Dialog Box At Startup
  • Can anyone tell me how to clear the history on the Open Existing Database dialog box that pops up when you first open Access. I don't want to inadvertently open the wrong database.
    page tag? Write To A Memo Field UtfBZGNvcmldHQMw
• 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? Write To A Memo 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? Write To A Memo 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? Write To A Memo 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? Write To A Memo Field UtfBRGFsZSBGeWU
• 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? Write To A Memo Field UtfBYmFicw
• 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? Write To A Memo Field UtfBbWhlbnNoYXcNg
• Runtime - Microsoft Office Access Security Notice
  • I have a split ac2007 database that is on a server, two different folders. When I have a user run the frontend from thier PC, they have runtime, they get the Access 2007 Security Warning Box.I think that I have tried everything to stop this from happening, but I cannot get it to stop.I do not want to place the frontend on each users PC.Thanks for any suggestions.
    page tag? Write To A Memo Field Bills
• 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? Write To A Memo Field UtfBamVYW
• 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? Write To A Memo 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? Write To A Memo Field UtfBTnlsZXg
• 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? Write To A Memo Field UtfBTWlhdGFNWDU
• Messages Received
  • We have received three messages from you thus far.I'm glad you found a good reataurant.I'd stick with them as much as possible.We went to Billy's for our anniversary. I ordered the most expensive item ($15) on thetwighlight menu. It wa sea food au gratin. It contained only two small shrimp and the restwas baked cheese. I told the waiter they forgot the sea food. He said that is all youget on the twighlight menu and that there was shredded crab in the cheese sauce.That is the end of Billy's. The bill and tip came to $35 and all I ate was two very small shrimp. Love, Dad
    page tag? Write To A Memo Field Richard Fitzpatrick
• Tesste
  • teste
    page tag? Write To A Memo Field Aristides Junior
• Update Checkbox
  • I would like to update a checkbox once a Date as been entered in my date field on a form.
    page tag? Write To A Memo Field UtfBTyuLi
• Karen Shultz
  • hey karen how r u doing i just wanted to say hey and DOYOUWANTTOBEMYFRIEND?
    page tag? Write To A Memo Field T
• Not In List Event Problem
  • I'm trying to set up where a a form is used to update a master record. This forms has a combo box to select a client. I want to update the table that that supports the combo box when an entry is made that is not on the table.I'm using the Not in List event and the following code:Private Sub Client_Name_NotInList(NewData As String, Response As Integer) Dim strTmp As String ' Get confirmation that this is not just a spelling error. strTmp = "Add '" & NewData & "' as a new Client?" If MsgBox(strTmp, vbYesNo + vbDefaultButton2 + vbQuestion, "Not in List") = vbYes Then ' Append the NewData as a record in the Clients table. strTmp = "INSERT INTO Clients ( CLIENT NAME ) " & _ "SELECT """ & NewData & """ AS CLIENT NAME;" DBEngine(0)(0).Execute strTmp, dbFailOnError 'Notify Access about the new record, so it requeries the combo. Response = acDataErrAdded End If End SubI get a Run-time error '3134' and Syntax error in INSERT INTO statement.I can not see or find the syntax error. Please help.
    page tag? Write To A Memo Field Bills
• Task Bar
  • Suddenly my task bar appear vertically on the right of my desktop. How can i change it ?
    page tag? Write To A Memo 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? Write To A Memo Field John Taylor
• I Want To Share My Calibration Database And Troubles Database
  • I work in the quality field and over the years, I've developed a "Calibration Database" and a "Troubles Database" that I have used at a couple of different companies. The databases are VERY basic - no fancy programming, etc. They are also not created with fancy opening screens, etc. I've worked for small companies where I was the only person entering and extracting data. I am unsure how to put these databases out there for others to use and/or build on. -- Glenda
    page tag? Write To A Memo Field UtfBRxlbmRh
• 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? Write To A Memo Field Milhouse Van Houten
• Auto Number With Data Information
  • Anyone can help to combine data into auto number below:data1 data2 date3AAA BBB 01/OCT/09Normally auto number will only create by system as:1.2.3.4.5.6.7.8.................refer to the above, possible to combine data1...3 into auto number as below:AAA-BBB-091001-01 / AAA-BBB-CCC-901001-02 ............ Thanks YouTom
    page tag? Write To A Memo Field UtfBdGt
• 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? Write To A Memo Field UtfBSmFrZSBG
• 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? Write To A Memo Field Gaby Sandoval
• Calculation With Not Equal To
  • While I'm in the Immediate Window in Access I type the following calculation and it gives me the wrong answer, what could be causing this?? 100.70-100.69 1.00000000000051E-02 It should give me 0.01, no?The reason why I'm doing this is because I have a function that compares calculated fields and for some reason Access tells me it's not valid when it is in fact valid.This function does some comparisons like:If Me.txtField1 <> Me.txtField2 - Me.txtField3 then Valid = FalseElse Valid = TrueEndifWhen I debug, I see the values and it should return True, but instead it returns False. So I decided to retype the same values in the Immediate window and I get the above. Which is wrong.Any help would be appreciated. This is just weird.Thanks in advance
    page tag? Write To A Memo Field UtfBUmFIEM
• 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? Write To A Memo 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? Write To A Memo Field daniel
• Enlarge Toolbar Size/Font
  • Is there a way in Access 2000 to enlarge toolbar size or font without using the "Large Icon" option (which changes the menu size in all office programs)? Thanks
    page tag? Write To A Memo Field UtfBUFBDTw
• Can Access 2007 Do This???
  • Im new to this so everything that i have so far has been using the wizard not coding it myselfi have a simple form with 3 tabs so far... i have dates in most of my boxes on the form... i know how to make the date change color if it is expired or past due... is there a way that if date1 is expired i can make it appear on a seperate tab?
    page tag? Write To A Memo Field UtfBQmxZWxpbmVyOTc
• Accmdunhidecolumns
  • Question on a little code:Access2007 I have a form "frmFilter" and a subform "frmFilterContacts"The subform is a datasheet.I have a button on frmFilter with the following code:Private Sub cmdShowHideFields_Click() Me.frmFilterContacts1.SetFocus DoCmd.RunCommand acCmdUnhideColumns DoCmd.SaveEnd SubThe first two lines work fine and popup the list of fields in the datasheet and allow the user to change which ones are shown/hidden.The question is how do I suppress the "Do you want to save changes to the design of form "frmFilterContacts"?The DoCmd.Save suppressed the same question on "frmFilter".I tried a few things but thought this was a good question for the newsgroup.Thanks,Mark
    page tag? Write To A Memo Field Mark Andrews
• 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? Write To A Memo Field Eric D Braden
• Hohj
  • 
    page tag? Write To A Memo Field marti misselis
• 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? Write To A Memo Field David G
• Confimation
  • again tis is to confirm connection
    page tag? Write To A Memo 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? Write To A Memo Field mrwawa
• Access 2007 Runtime
  • I am wanting to now if the following:Microsoft Office Access Runtime and Data Connectivity Components 2007 Service Pack 2 (SP2)will fix the problem with the access database not exporting a report to excel. I know the office 2007 service pack 2 will fix this problem for the full version of Access but what about the runtime that is distributed. Will the above fix it or is there another service pack to have the client install?
    page tag? Write To A Memo Field UtfBRGFsZQ
• 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? Write To A Memo Field UtfBenlcw
• 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? Write To A Memo Field UtfBSGFycmlldA
• 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? Write To A Memo 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? Write To A Memo Field UtfBaF
• I Cannot Run A Query In Access 2007 That Joins To Paradox
  • Error message when running query in Access 2007:You are attempting to work with a Paradox file that requires the Borland Database Engine (BDE). Microsoft Office Access cannot load the BDE, or the BDE is not correctly installed. To correct this, run the setup program for the BDE.My Issue:I cannot run a heterogeneous query on Vista and Access 2007 even though the BDE is installed.It runs fine on another Win XP computer with Access 2002 installed. In summary:Vista: Access 2007, Paradox 11.0.0.411, BDE version 5.2.0.2. Ran BDE Info Utility test successfully.XP: Access 2002, Paradox 11.0.0.411, BDE version 5.2.0.2. Ran BDE Info Utility test successfully.On Vista, the BDE Information Utility says IDAPI32.DLL is not found but it is there in the correct place ‘C:\Program Files\Common Files\Borland Shared\BDE’ though it is in lower case.In the BDE Information utility, instead of the version number displayed it says “C:\Program Files\Common Files\Borland Shared\BDE;C:\Program Files\Common Files\Borland Shared\BDE\IDAPI32.DLL not found.”Should I uninstall BDE and re-install? This is a large task.
    page tag? Write To A Memo Field UtfBZHYOTk
• 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? Write To A Memo Field UtfBQmiIEJhcmlcw
• 123456
  • jopieuret
    page tag? Write To A Memo Field sdsd
• Ziaoganxh
  • e er ni nuosheng zun hai er
    page tag? Write To A Memo Field zx
• Gklds
  • liusenlin
    page tag? Write To A Memo Field tom
• Happy
  • ¿ìÀÖÿһÌì
    page tag? Write To A Memo Field happylulu
• Sdf
  • sdfsd
    page tag? Write To A Memo Field princess
• Combo Box & Search Function
  • I'm trying to help someone who inherited a database that really needs to be re-worked, but she has to get a database released within a few days. Neither one of us has used Access in recently, so any help you can give would be great. I've been searching for a response, but can't seem to get any non-VBA solutions to work. We plan to attend training, but are in emergency mode now. Two question.Question #1 Display Employee Number when Employee Name is selected Table:C3 Employee Master.Name (form control Name is Employee Name & is a combo box)C3 Employee Master.Agent_ID (form Name is ID# & is a textbox)Form Name = "Name" & is a look-up from the C3 Employee Master.name tableForm Name = "ID #" & is a look-up from the same table [Agent_ID]I tried to accomplish this by entering this in the Control Source for the Employee Number field but I'm wondering if I need an AfterEvent on the Employee Name fields:=DLookUp("[Agent ID]","[C3 Employee Master]","[Name] = Forms![Employee Name]")Question #2 Add a Search function. If any one of the following 3 fields are entered in the form, display the associated records from one of 3 tables:Tables:C3 Employee Master.Name QA Master.ManagerCall Form Table: Values input on form are written to this tableForm Name = "Name" & is a look-up from the C3 Employee Master.name tableForm Name = "QA Name" & is a look-up from the QA Master.Manager tableForm Name = Ref No & is a user input-- Thanks!Chris
    page tag? Write To A Memo Field UtfBQhyaXM
• Upgrading 95 Databases & Using Runtime
  • I need to update some Access 95 databases to overcome the 1GB ramlimit of Access 95.I have Access 2000.1. What are common hurdles to expect when upgrading 95 databases to2000?2. Is the Access 2000 Runtime available anywhere?3. WIll the Access 2007 Runtime read Access 2000 files?Thanks!Rob
    page tag? Write To A Memo Field rob
• Vba
  • disable the tabs of security
    page tag? Write To A Memo Field UtfBdmlrcmFt
• Ssma Linking Tables
  • I used SSMA to upsize Access2003 to SQL2005. The wizard automatically created Linked tables to the database. Now I created new tables in SQL that I want to link using the same connection as the current linked tables. How do I find where or how that ODBC connection is setup?
    page tag? Write To A Memo Field UtfBQWxpZWz
• 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? Write To A Memo Field Sinner
• 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? Write To A Memo Field JB
• Hifi
  • 
    page tag? Write To A Memo Field francis monville
• Design Question (Normalization Versus Practical)
  • In my app I have a main table with about 22 fields of which 8 have repeating values which, according to normalization, require their own tables which should be linked by a meaningless ID number. Also this main table is linked to 2 1XM tables.On the other hand I'm quite happy with the table as it it. My forms load very quick, the datamodel is simple, I don't have to drag multiple tables every time I run a query. When I choose proper normalization I'm afraid to wind up with a very large datamodel which will load much slower. Also, I think it will make developing more cumbersome. The benefit I think will be a smaller *.mdb. Also when you want to change a value, you only have to do it once. But will it be worth the effort?Any thoughts?Thanks, Lars
    page tag? Write To A Memo Field Lars Brownies
• Remove Borders When Ms Access 2007 Performs An Export To Excel?
  • Hi,I have ms access macros that export tables to several different excel workbooks, but it sometimes inserts borders around some or all of the data in excel when the export command executes. Is there a way to stop ms access from doing that? It messes up the clean formatting that I have set up in the worksheet. I don't want the borders in automatically adds to the data in the spreadsheet.Thanks for your time.
    page tag? Write To A Memo Field UtfBVGVlbmEgTS
• Modifying/Appending Records Between Subforms
  • I need some guidance and perhaps some inspiration. I'm working on a database containing a main form with 2 subforms side by side. Subform1 is a continuous form that has records about the positions a military unit has. Subform2 is a continuous form that starts out wth no records.Basic Subform1 record fields: UIC, Para, Line, Auth Str, Req StrCombo PK on UIC, Para, LineWhat I'm trying to do is to 'maybe' click a command button on a record in Subform 1 and have the data of that record append to Subform2. While doing this it should subtract 1 from Auth Str and Req Str, and change the appended record's UIC to the contents of an unbound text field on Subform2. If Auth Str and Req Str would end up being "0", then it should append then delete that record from Subform1. When the append to Subform2 takes place, it should either add that record, if it doesn't exist, or add 1 to the Auth Str and Req Str.In case the user made a mistake, Subform 2 will have a similar command button to carry out the same action.I was hoping someone could point me in the right direction.
    page tag? Write To A Memo Field UtfBRGFaWQgTXVsaGsbGFuZA
• Hola
  • 
    page tag? Write To A Memo Field jimenita
• 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? Write To A Memo Field hugh welford
• Images Issues With Access 2007
  • Hi everybody,Since years I have an Acces 2k program with forms and reports.Each Forms contain an BoundObjectFrame, which links to the appropriate TIF images, using VBA.Each Reports have the same (ImageControl) in order to print a sheet conaining data and the TIF image.Since this MDE program is now, for the 1st time, installed on an Office 2007 suite, with Access 2007, the images do not display at all and reports print a blank image.And without any err message at all.Any similar experience on that subjet will be greatly appreciated.Many thanks in advanceBruno
    page tag? Write To A Memo Field Bruno Frisque
• Button In Toolbar That Runs Vba Code
  • Hey all,I'm trying to add a button to a toolbar in MS Access 2007 and by clicking that button let him to run some own written vba code.But I cant find an option to write vba code behind a button.I've tried to make a macro that runs a procedure, but I get the error all the time that Access cant find that procedure...Made a module called Email:Option Compare DatabasePublic Function email() mailEnd FunctionPublic Sub mail() MsgBox "test"End SubAnd then make a macro that runs email()Can somebody help me in the right direction?Kind regards,Erwin
    page tag? Write To A Memo Field Erwin Bormans
• 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? Write To A Memo Field UtfBQhyaXM
• Class
  • HelloI want to dropyou class buti dont how to doand want to ask youif you can help mepleaseThanksAdriana Gaona
    page tag? Write To A Memo Field Adriana
• Losing Table Index
  • I have a secondary table that contain various fields that hold the indexes of other table records. This secondary table is independent of the primary table that contains the records.Question:1) When I repair or compact the DB, do table indexes change?2) Is there anyway to save the indexes of the primary tables in a secondary table field and maintain the link to the primary table such that if the primary table record index changes (e.g. repair or compaction) the secondary table fields (which hold the index values) also change?ThanksDavid
    page tag? Write To A Memo Field David
• 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? Write To A Memo Field UtfBYndpbGsNw
• Faut Elle Aussi
  • je suis manque d ero alor que j ai prie d ero
    page tag? Write To A Memo Field fabien carpignano
• Prova
  • ciao ciao!
    page tag? Write To A Memo Field Torelli Tatiana
• 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? Write To A Memo Field UtfBUHJvZJhbURvYw
• 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? Write To A Memo Field UtfBTWFsZG
• 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? Write To A Memo Field UtfBYFydGVy
• Strike Over Key
  • I just installed Windows/Word 2007 after having 2003. Same keyboard and computer. My "insert" key no longer works-- any suggestions?
    page tag? Write To A Memo Field UtfBTGluZGVybHU
• 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? Write To A Memo Field UtfBbGjaVkIHZpaFz
• Access 2007 Ribbons
  • i've just upgraded to access 2007 from 2003 so still getting use to it. i have created some new ribbons using IDBE ribbon creator, they seem to work fine.in options - current database - ribbon and toolbar options i have my new ribbon selected under ribbon nameshortcut menu bar set to defaultunchecked allow full menus and allow default shortcut menusthe problem is, when i open my database, i have my new ribbon + the home tab and acrobat tab. hod do i display only my new tab??
    page tag? Write To A Memo Field UtfBURSms
• Order Entry
  • I have two tables related as one to many. The first table is"tblOrders" the many side "tblProducts". I would like the user tochoose from one to many products and after choosing, click a buttonthat assigns a unique order number in the tblOrders table. Should theuser at any time decide to cancel the whole thing, then that uniqueorder number would not be used and no record would be created. I wantto avoid autonumber since the order number will reset each month (eg S(yr)-(month)-(No)).What is the best way to accomplish this?Dave
    page tag? Write To A Memo Field Dave
• 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? Write To A Memo Field UtfBTko
• 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? Write To A Memo Field UtfBQnVuak
• 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? Write To A Memo 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? Write To A Memo Field jodleren
• Requery Combo Boxes
  • On my form I have two combo boxes, Supervisor and Specialist. Obviously, the Specialist is driven by the Supervisor that is chosen. You have many Specialists to one supervisor. These both are populated by queries. The first time a selection is done, everything populates correctly. When a different supervisor is chosen, it does not requery for the specialists associated with the new supervisor selection. I have put in requery statements on the Form - On Current event and tried coding them in the combobox after update event. I cannot get them to fire again. I tried to go the website that Mr. Sheridan suggested on another post but it is blocked by our system. Any help will be greatly appreciated.
    page tag? Write To A Memo Field UtfBQnVuak
• Hello
  • nice to meet you
    page tag? Write To A Memo Field gbBwfWobrG