Tab Control To Open When Record Selected

Recent Posts

• Displaying Info In An Unbound Text Box And Locking For Editing
  • Hi everybody,I have an unbound text box called "txtStartDateReadOnly" on a formcalled "frmContactInfo". I would like txtStartDateReadOnly to displaydata from a bound text box on another form, but have it greyed out andlocked for editing. This other form is called "frmAppointments" andthe text box in question is called "txtStartDate".txtStartDate is normally invisible, but becomes invisible when a "yes"value is selected in a combo box called "cboAppointment".The underlying tables between frmContactInfo (tblStaffMain) andfrmAppointments (tblAppointments) have a one-to-many relationship: onerecord in tblStaffMain can have many records in tblAppointments. Iwant the unbound combo box (txtStartDateReadOnly) to pull only themost recent appointment.I hope that all makes sense. :) Any help would be much appreciated.Thanks!
    page tag? Tab Control To Open When Record Selected Bellyjeans
• 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? Tab Control To Open When Record Selected UtfBSmVmZiBD
• Search Records By Date
  • Hi everyone,I Have the following structure table:YEAR | MONTH | 1 | 2 | 3 | 4 | 5 |........| 29 | 30 | 31 |-----------------------------------------------------------------2009 | 10 | 5 | 0 | 6 |What i need is to filter by date, for example by clicking in a command button, i woul like to obtain the value of current day, for example, the 3rd October, i would like to click in a button and get the value 6 -- Thanks, Sorry if my english isn''t correct, but I''m from Potugal ;)Emanuel Violante Galeano
    page tag? Tab Control To Open When Record Selected UtfBRWhbnVlbCBWaWsYWZQ
• 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? Tab Control To Open When Record Selected UtfBTWFyeQ
• Create One Table Using Multiple Linked Tables
  • I have multiple linked tables in my db from multiple db's. I would like all of those linked tables in one 'master' table. The linked tables all have the exact same structure. Right now I am manually creating one 'master' table with all the data, but anytime the data in the linked table is updated I have to re-create the 'master' table.
    page tag? Tab Control To Open When Record Selected UtfBaxrcmwZg
• 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? Tab Control To Open When Record Selected UtfBQlpleWdlcg
• Forms Disappearing
  • I am working in access 2007 I was working in a form and all of the information in the form disappeared. I closed down and restarted-nothing. When I tried to build a new form it disappears as well. It shows up in design mode but not in any other mode. Any ideas?
    page tag? Tab Control To Open When Record Selected UtfBeWyallbGZXIwMg
• 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? Tab Control To Open When Record Selected isoQJosEPraxedes
• Compatability Pack
  • I have 2003 version of Word. Installed new hard drive so lost all. Which compatability pack is needed to view 2007 Word documents.
    page tag? Tab Control To Open When Record Selected UtfBSmluZXk
• Can Anyone Explain This Intolerable Latency On A Wan?
  • I have some clients (there are about six team members) working on anAccess 2003 Front End which is connected by a WAN to an Access 2003Back End some hundred or so miles away.When the application starts there are some housekeeping operationsthat take place (some once a day when the first person logs on, otherswhen anyone logs on) before the initial screen is displayed. When theback-end used to be hosted locally the time to display the firstscreen was a matter of five or ten seconds. Now that the back-end ison the WAN it typically takes TWENTY FIVE MINUTES before the firstscreen is displayed.I've tested the network connection by copying the back-end database inits entirety onto a local machine. It's only 55 Mb and the copy tookabout 55 seconds. I've also configured the application to connect tothe local copy and it runs much, much quicker.Since the network connection *seems* ok, can anyone suggest any otherpossible candidates for the unusable latency that my clients areexperiencing? They are a small team in an enormous organisation witha very uncooperative IT Support department.ThanksEdward
    page tag? Tab Control To Open When Record Selected Edward
• 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? Tab Control To Open When Record Selected 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? Tab Control To Open When Record Selected UtfBZGNvcmldHQMw
• Count Number Of Items In A Listbox
  • Hello,I am new to Access. I have a form with a list box named lstProject that gets it data from a table (table_Project). The list box works fine. It shows all of my desired results. I would like to place a textbox (txtCount) underneath the listbox to count how many records appear in the list box.Is there an easy way to do this? I was not sure what code I would need to put in.
    page tag? Tab Control To Open When Record Selected UtfBQlpleWdlcg
• 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? Tab Control To Open When Record Selected John Nipper
• Cannot Link Foxpro File As Table, Access2000
  • I have to fix a screwy access database made a long time ago. It has a linked table going to a DBF file. The connect string for the table is:ODBC;DSN=Visual FoxPro Tables;SourceDB=\\DPH53501\VOL1\Unitdata\Central_Ops\FCM Cornerstone Reports\FCMData;SourceType=DBF;Exclusive=No;BackgroundFetch=Yes;Collate=Machine;Null=Yes;Deleted=Yes;The user receives an email attachment and saves the attachment at the designated path. The attachment is an Excel spreadsheet with file extension xls, but is renamed and saved as dbf. I don't know what process is used by the sender and whether it's really made as an Excel spreadsheet or Foxpro file.Things worked a long time, but the file format has changed to have different columns. Personnel changed, too. Whoever linked the table isn't here anymore.When I try to make a new link I'm unable. If I use dbase (dbf file type) III, IV, or V it says I have to have an index table, too. There is no index table associated with the previous linked table, so that probably isn't right. If I try to use ODBC as indicated in the previous connect string, there are Foxpro files, Foxpro tables, and Foxpro database, as options in the dropdown and none of them work.If I try to use Excel or "Foxpro files", I get a message saying "you cannot use ODBC to import from, export to, or link an external Microsoft Jet or ISAM table to your database". Possibly I should be able to use one of these and this is an install or configuration issue.How can I tell what the attachment is? Excel will open it. The dbf file type is associated with Excel on this machine.Help would be appreciated.
    page tag? Tab Control To Open When Record Selected UtfBZGdt
• Open Multiple Instances On One Pc...
  • Hi,We have a bunch of access adps used as front ends for SQL server databases and recently converted to Access 2007. The problem is that Access 2007 apparently wants to modify the adp which is causing two issues.First, because the adp is opened for writing, attempting to open a second instance forces the second instance to be opened in "read only" mode which displays a save as dialog to save a copy of the adp under a different name. Because it's connected to an SQL server for data storage, there is nothing in the adp that should be changed...so opening in read only mode would be fine if not for the warning message and "save as" option. In fact...opening in read only mode would fix the secon issue...The second issue is that we use a "loader app" which examines the date/time stamp of the adp to determine if it's the latest version. Since the file is always opened for reading...the file date/time stamp gets updated every time the adp is opened. That is interfering with our ability to determine if there is a newer version available.So...what I'm looking for is a means to suppress the read only warning. I can understand displaying a warning if it's opening the file as read only because of a file lock. But if I'm opening the file read only by using the "/ro" command line switch, do I really need a warning? It seems silly to warn me about something that I'm obviously doing deliberately. And it's down right aggravating when there is no way to override that warning.
    page tag? Tab Control To Open When Record Selected UtfBUmF
• Two Different Characters In String
  • Hello,I am using Access 2003 and trying to create a query that separates the last name from a field of last name/first name combo. My data can look like thisJones, Adamor can look like this:Jones|AdamI currently use Left(qryMHTracking!LName,InStr(qryMHTracking!LName,",")-1) which does fine for the names with a comma in them. I cannot seem to find a way where I can evaluate both instances (, and |) to yield the last name by itself.Any help?
    page tag? Tab Control To Open When Record Selected UtfBUFQMg
• 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? Tab Control To Open When Record Selected UtfBZVvcmdlbYgdGhlIGpbmdsZQ
• 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? Tab Control To Open When Record Selected Bills
• Trial
  • hi lennox
    page tag? Tab Control To Open When Record Selected Craigs
• 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? Tab Control To Open When Record Selected UtfBamVYW
• 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? Tab Control To Open When Record Selected UtfBTkFT
• How Do I Cahnge My Profile?
  • I ahve a new e-mail and I need to phase out my old e-mail.Where do I change my e-mail to sign in to the Microsoft websites Newsgroups that I visit occasionally using Intternet Explorer?Thanks in advance.
    page tag? Tab Control To Open When Record Selected UtfBTNYXZpbw
• Time Range Question
  • HiHow can I check that time range defined by given [Start] and [End] values has at least some of it lying in the range 00:00 to 07:00?ThanksRegards
    page tag? Tab Control To Open When Record Selected John
• Update Checkbox
  • I would like to update a checkbox once a Date as been entered in my date field on a form.
    page tag? Tab Control To Open When Record Selected UtfBTyuLi
• Filter Subform
  • After selecting a name from my dropdown box (top of form) the subform updates and reflects all records by that name. Can I add two boxes to reflect the subform by by month or by upc? (access 2003)I just want to use one of the choices at a time, reflect subform information by name, by month, or by upc...Thank You for your time.
    page tag? Tab Control To Open When Record Selected UtfBSHVtYmxlZCBMZWFybmVy
• 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? Tab Control To Open When Record Selected UtfBURldmU
• Jpb
  • why did you put lotus notes email and oh, ya what does lotus notes email mean?
    page tag? Tab Control To Open When Record Selected T
• 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? Tab Control To Open When Record Selected UtfBcGVtdA
• Is This Possible ??
  • Hello guys,I have a text field with descriptions as follows:SPOT TWIST GU10 50W BLIS 16751LAMPTB 400W E40 GE MHL 30052I want to format them as such so that the last 5 digits of the string diplay as follows:SPOT TWIST GU10 50W BLIS *****LAMPTB 400W E40 GE MHL ***** How should I do this?Thanks in advance!
    page tag? Tab Control To Open When Record Selected UtfBRWFybCBSEgSiBbGxhZGllbiBpbiBhYNlcMgZmydWhIQ
• Insert Headers & Footers In Access 2007
  • How do you insert headers & footers into a table in Access 2007 ?
    page tag? Tab Control To Open When Record Selected UtfBVViYmVdGE
• Monthly Inventory Report
  • I am setting up an inventory program that requires a monthy billing report that shows each departments totals for products ordered and what their monthy charge is. This report must be divided by each department. Currently it says there is a problem in the "FROM" line but has also said there is problems in the "INNER JOIN" areas. My Database properties for this form is as follows. The report is accessed by a date peramiter box;SELECT DISTINCTROW Products2.StockNu, Products2.ProductName, Dept2.Cust2, Dept2.DeptName, [Products2].AvgUnitPrice AS [Avg Unit Price], Sum([Req1].QuantityIssued) AS [Total Units] FROM Products2 INNER JOIN (Dept2 INNER JOIN [Req1]. ON ([ Dept2].Cust2=[Req1].Cust) ON Products2.StockNu=[Req1].StockNu2) WHERE (([Req1].ReqFilledDate)<=forms![Report Date Range]!BeginDate) And ([Req1].ReqFilledDate<=forms![Report Date Range]!EndDate) GROUP BY Products2.StockNu, Products2.ProductName, Dept2.Cust2, Dept2.Name;Unfortunatly this does not work. My tables are: Products2, holds all product infoReq1, holds requisition info from departmentsDept2, Info for all departments
    page tag? Tab Control To Open When Record Selected UtfBSHViYnlNYXg
• Logging Incremental Changes
  • I have several tables of thousands of records each. The data isimported daily from excel sheets or flat files that I receive from thedata originator. Because the data set is so large, I can only keep thefull set of the current data. But it's become increasingly importantto find a way to log any changes that are made to the data from day today.The best advice I've received so far is to try the DISTINCTROWpredicate in SQL. That would be great if we weren't talking about somany records. Not only would I exceed the limits of Access in shortorder, I would also be storing a lot of redundant data.What I really would like to end up with is a log table for each maintable that is almost an exact copy. The difference would be that thefields in the log table would only be populated if they are differentfrom the previous day's data.For example, given an initial record for a particular employee in themain table like the following:tbl_empdate_imported emp_id emp_loca emp_health emp_rating09OCT2010 FB6K2 Georgia Green GreenAfter several weeks of imports that replace the original, the recordin the main table will look like the following:tbl_empdate_imported emp_id emp_loca emp_health emp_rating21OCT2010 FB6K2 Florida Yellow RedI want to end up with a change log that looks like the following:tbl_emp_chg_logdate_imported emp_id emp_loca emp_health emp_rating09OCT2010 FB6K2 Florida11OCT2010 FB6K2 Yellow15OCT2010 FB6K2 Red21OCT2010 FB6K2 YellowIf I were editing the data myself, I would just create a changetransaction log as there are a variety of strategies on the subject.But I need a way to compare field for field changes during the import,and then log only the fields that differ from the existing data,thousand of records each day.I have a couple of ideas to approach it, but I'm pretty sure there's amore efficient way than FOR - EACHing through each field of eachrecord. It would not only take a long time, but I've already run intoproblems writing code that tries to step through every field of everyrecord in such a large data set.Even if someone that recognizes this as a known problem set and couldrecommend search terms that would help lead me to the right path, Iwould be so thankful. My searches and brainstorming are coming upempty.
    page tag? Tab Control To Open When Record Selected Mac
• What
  • What!
    page tag? Tab Control To Open When Record Selected tom
• Monthly Reports - Macro Count
  • Hello community ^_^ I'm in the need of some help!I got 2 questions that hopefully you guys can help me find the answerFirst,The function of the database is to store the information of printer cartridges. We normally do storage count every month, so I need a report to print out how many cartridges were used based on the count in the storage room and the new count. So basiclly OldCount-NewCount.NewCount: will be inputted by user.Total Used: NewCount-OldCountOldCount: after the calculation, it will then get the value from NewCountHow can I be able to do that in a form?Second,I would like to know how can I create a report that will ask me an StartDate and an EndDate and depending on the info inserted it will display the records. This is to display the TOTAL USED cartridges used per month.Database Structure:- Table (Storage) the table contains these fields: Manufacturer, Model, Category (all referring to the cartridges) a field for Storage (I use this for oldcount) and the Count field (we can use this as newcount), Total Used (empty, but on the query I set it as Storage-Count) StartDate and EndDate fields empty.- Form (Storage) is based on the Table.- Query (Storage) displays all fields from the table.I really appreciate any help, and I'm willing to mail a copy of the database if anybody wants to take a deeper look into it.~Manny
    page tag? Tab Control To Open When Record Selected UtfBTGjbJhbnM
• 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? Tab Control To Open When Record Selected 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? Tab Control To Open When Record Selected 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? Tab Control To Open When Record Selected UtfBUGhpbA
• Export Schema Problems
  • I'm working on some code to export the schema from an mdb. It's not letting me get the info on queries that are embeded in form dropdowns, list boxes, etc. Dim qd As QueryDef For Each qd In db.QueryDefs Application.ExportXML ObjectType:=acExportQuery, DataSource:=qd.Name, SchemaTarget:=sWhereToStore & qd.Name & ".xsd" Next qdWhen the above code runs it works fine except for what I mentioned. When it gets to a query that's in a form it tells me the query doesn't exist. For example in a form called "frmAddEditCertHolders" I have a combo box for states where the source for the query is just something like "Select * from tblStates". The name of the query for the combo ends up being this: ~sq_cfrmAddEditCertHolders~sq_cStateCode. If I do a debug.print qd.SQL it gives me the SQL for it but I want more than that. How can I get ExportXML to recognized these queries?When I run ExportXML on my forms, it doesn't give me any embeded query information.It also only lets you export xml for Select, Crosstb and Union queries. Why is this so limited??? How can I get around this?Thanks,Keith
    page tag? Tab Control To Open When Record Selected Keith G Hicks
• Ole Object In Ms Access With Bitmap Files
  • HiI desined a data base (mdb) that includes a ole object , the expected file is bitmab file , and it was working fine by inserting the bmp files ,, but suddenly i got different content while inserting the bitmap files it changes to package content instaed of bitmap object . and instead of getting the picture in the box i got the small icon with the name of the file .so what could be the reason for that ?hanks
    page tag? Tab Control To Open When Record Selected UtfBTxFIECSkVDVCBJTiBNUyBBQNFUMgVlUSCBCSVRNQVAgRklMRQ
• Updating/Changing Mde Databases
  • I am using an FTP process for transferring data. In the past I have done this several times using mdb databases. The user would download a file, the file would open and perform certain functions, close and open a different database.Using this system I was able to get new forms, tables, queries, etc. to the users. In the Autoexec macro of the file they downloaded and opened. I would use the copy object method to export new objects to the other databases. I am now using a similar FTP methodology but with mde files. Is there a way to export to and/or replace objects in an mde file, or do I have to replace the entire file? This is a very complex program. The FE is 450 mb. Is replacing the entire FE the only way to make changes in the mde files?Thank you for your help.
    page tag? Tab Control To Open When Record Selected UtfBQXJdXJv
• 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? Tab Control To Open When Record Selected Mark Andrews
• Append Query Question Regarding Nulling Data
  • HiI have an append query that is working fine. But for some of the fields, if they contain certain values, I want them to be nulled out when they are appended. For instance if the status is anything other than 'Confirmed', I want it to be nulled when appended.Does anyone know how to do this?thanks-- Nancy
    page tag? Tab Control To Open When Record Selected UtfBTnVycUgTmFuYk
• Msg Box With Conditions And Display A Value From Form On Message
  • Hi,I have a Control button on a form that opens another form, I want to display a message pop up on the new form if a calculated value on that form is greater than 0, then the user can choose to close the new form or ignore the warning.If it's less than Zero, then i would disply a different pop up message.I have 3 problems,, and if anyone can help with any one of them,, i would be ever so greatful!1. Where do i put the VB for the popup message,, so I can see the form open and make a decision on whether to close it.When i put it on the 2nd form property sheet,,,On current - It displays after i hit the control-button, while I am still on the first form so I can't see the new form openOn Focus - It displays while i am still on the first form so i can't see the new formOn Click - Nothing happens, I don't get a messageI ended up putting it on the detail section of the new form and now whenever I click on that, i get the message,, i only want it once after the form opens.ANy suggestions?2. I only want the pop up message to display if the value of a calculated field is greater than zero and I want to display the value in the message.The field is called Diff TB on the form and is calculated as Sum([Prime Rate]*[Prime Spots]+[Rot Rate]*[Rot Spots]+[Other Rate]*[Other Spots])I don't know VB and when i tried to use the calc as is,, i get a syntax error3. How do i code it so if it's greater than zero, i display a different message?Here's the code without the calc, which also doesn't workPrivate Sub Detail_Click()If [Diff TB] > 0 ThenDim Msg, Style, Title, Help, Ctxt, Response, MyStringMsg = "Weekly Budget is Greater Than Total Perspective Buys, Do you want to Add More Stations? Weekly Budget = $$$$$$, Diff = $$$$$$$"Style = vbYesNo + vbDefaultButton2Title = "MsgBox Demonstration"Help = "DEMO.HLP"Ctxt = 1000End IfResponse = MsgBox(Msg, Style, Title, Help, Ctxt)If Response = vbYes Then ' User chose Yes. MyString = "Yes" DoCmd.RunCommand acCmdSaveRecord DoCmd.close acForm, "Weekly Buy Table Form", acSaveYes Else ' User chose No. MyString = "No" ' Do NothingEnd IfEnd Sub-- Nancy
    page tag? Tab Control To Open When Record Selected UtfBTnVycUgTmFuYk
• Iif & Qrycount
  • Hi,I would like to be able to use a single command button to either viewrecords on a form if they exist or go to a new record form if theydont. I've created a qryCount but when I tried adding this to mysearch form it restricted search results to a single return and I'vetried using If then else in VBA but have gone wrong there too.Any help would be appreciated.DonH
    page tag? Tab Control To Open When Record Selected don
• Hello
  • How are you everybody
    page tag? Tab Control To Open When Record Selected Roque Silva Morgado
• Confimation
  • again tis is to confirm connection
    page tag? Tab Control To Open When Record Selected Roy Eaton
• 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? Tab Control To Open When Record Selected UtfBenlcw
• Problem With Ie8 Instalation
  • I've got a windows XP starter edition in my PC and i'm trying to install the internet explorer 8 but I receive from the PC warning saying that the installation don't give the suport to actual operational sistem language and for that I am not able to install the ineternet explorer 8. What do I have to do?
    page tag? Tab Control To Open When Record Selected UtfBTHVpeiBNYWNvbGE
• 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? Tab Control To Open When Record Selected UtfBQhpcnM
• Requisition Form
  • I have designed a Requisition form to record products delivered to customers. My problem is that I can only include 1 input line for products delivered. Quantity Ordered, Unit Type, Product Number, Product Description, Quantity IssuedHow do I enter more than 1 item for the same for the same Requisition and have all items saved to the tabe as being part of the same Requisition?
    page tag? Tab Control To Open When Record Selected UtfBSHViYnlNYXg
• Alessio
  • 
    page tag? Tab Control To Open When Record Selected Alessio
• 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? Tab Control To Open When Record Selected UtfBaF
• Remove Add-In
  • I have Office 2007 running on a laptop with Windows Vista Home Premiun. I also have Adobe Acrobat 8 Standard. My add-in for Acrobat has stopped working but I can't remove it. Every time I try all I get is the following message:This add-in is installed for all users o n this computer, and can only be connected or disconnected by an administrator.I am the only person who uses this laptop and my user account is set as administrator. Can someone please tell me how to get this freaking crap to work right so that I can actually use my add-in.
    page tag? Tab Control To Open When Record Selected UtfBRGVlaiBIZXJuYWkZXo
• 12325487
  • fgfhhnytr
    page tag? Tab Control To Open When Record Selected sdsd
• 123
  • hi!
    page tag? Tab Control To Open When Record Selected yu
• Wangganghaha
  • 
    page tag? Tab Control To Open When Record Selected wangdan
• Xinwen
  • 
    page tag? Tab Control To Open When Record Selected msnews
• Sdf
  • sdfsd
    page tag? Tab Control To Open When Record Selected princess
• Happyningning
  • ningning
    page tag? Tab Control To Open When Record Selected hsppyningning
• 11111
  • 22222
    page tag? Tab Control To Open When Record Selected princess
• Populating Main Form After Changing Selection
  • On my main form I have fields displaying ticket #, group name ticket is assigned to and phone number for respect group. If I don’t have a phone number I am not displaying field for phone number.On same form I also have a subform on which I am displaying only open tickets.After clicking on ticket in a subform ticket is populated to fields in a main form, however in addition I would like to populate fields for a phone number or make them invisible when there is no phone number.Here is a code I am using:Private Sub Form_DblClick(Cancel As Integer)Dim lngTicket As LonglngTicket = Me.[Ticket #]Me.Parent.RequeryMe.Parent.Recordset.FindFirst "[Ticket #]=" & lngTicketForms![Remedy Tickets]![Status].SetFocusEnd SubI have a combo box I called Assignto and after selecting specific group phone numbers are provided for each group. I noticed that when I select specific ticket from subform main form is populated, but when I changed assigned group, phone number doesn’t change and it is a previous selection phone number. How I can update phone numbers when I want to change group name? Thanks
    page tag? Tab Control To Open When Record Selected UtfBRJlZw
• 2007 Comparison To Mde
  • I have never used 2007, but am starting a class in two weeks to get familiar with it. In the meantime I have a question.In the pre-2007 versions of Access you created in the MDB and converted it to MDE. What are the comparisons in 2007? What do you create it in, and what do you convert it to in order to get the file that is comparable to an MDE file?Thanks for your help?
    page tag? Tab Control To Open When Record Selected UtfBQXJdXJv
• Insert Data Into Access Database From Excel Userform
  • Hi All,I have a userform in excel that users would use to submit their details once they click "Submit" button on the form. I want the details to be stored in an Access database. But most of the users dont have access installed on their machine.My question is, Is it somehow possible to insert data in Access database through Userform if access is not installed on the local machine? We have a network drive which is shared among all and Access is installed on my machine. Can this be done?Thanks in advance.
    page tag? Tab Control To Open When Record Selected UtfBcFt
• How Do I Produce An Incrementing Index Of The Form "Frq000000"
  • 
    page tag? Tab Control To Open When Record Selected UtfBcXVpbnQ
• Single Front-End Interface For Reports And Forms
  • I have several reports and forms that I want to be accessed through a single menu.What's the best way to do this? Using forms, subforms, data access page or what?
    page tag? Tab Control To Open When Record Selected UtfBTGFcmE
• Hifi
  • 
    page tag? Tab Control To Open When Record Selected francis monville
• 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? Tab Control To Open When Record Selected UtfBVGVlbmEgTS
• Access 2000 & Publisher 2000
  • Hi,I have Access 2000 and Publisher 2000. I've created a file in publisher that I would like to place on one of my Access pages. Is this possible if so how? I tried insert/file, import, copy/paste and anything else I could think of. Copy/paste gave me something close, but some items were missing.Thanks,Phil-- Phil
    page tag? Tab Control To Open When Record Selected UtfBUGhpbA
• Phantom Network Drives Created?
  • Hi, we have a simple db created in Access 2003 that is installed on PCs running XP Pro and now Office 2007.At times when it's installed from always the same mapped drive letter (the db resides on a network drive) on the clientPCs several phantom drive letters appear on the target PCs. How can I stop this from happening?Let me know if I haven't adequately described the problem.Sam
    page tag? Tab Control To Open When Record Selected Sam
• Select Query W. Dlookup => 2 Secs., Make-Table Version => 2 Hrs.
  • Dear all,I have created a database with 35.000 records. In this database, I have created a query that uses the DLookup function to retrieve data. In "select" mode, this query takes about two seconds to finish. In "make-table" mode however, it takes two hours. Access seems to freeze ("Not responding"), but remains active as the database file size continually grows until query finishes in the end.Normally I use Access 2003, but to test this I have also tried Access 2007, again with the same result.The field I use for DLookup is indexed.Does somebody know more about the possible cause?Thanks,Gerwin RamakerNijmegen, NL
    page tag? Tab Control To Open When Record Selected UtfBRVydluIFJhbWFrZXI
• Hilsen Fra Slevik
  • Hallo ReidunTusen takk for hyggelig hilsen. Det var godt å lese at alt står bra til hos dere.Jeg skjønte ikke helt det med Tom og venninde, men det kan vi jo snakke om en annen gang.Jeg har nå gått over til en sprøyte som har 50 % større virkning enn den jeg tok tidligere.Kreft er jo ikke så lett å få tatt knekken på, men bare den kunne vokse litt saktere er jeg fornøyd.Vi hadde besøk av Ulf sist helg og det var hyggelig. Han er flink til å stikke innom når han først er i Sverige.Heidi sliter fortsatt med sin ME men hun er nå adskillig bedre, synes jeg. Hun har nylig kjøpt seg bolig på Gressvik som heldigvis ikke er mere enn 6-7 år gammel så der behøver ikke Sverre å gjøre så mye ennå.Nytt kjøkken og dobbelt så stort er det blitt i huset til Yvonne. Veggen mellom kjøkkenet og "kammerset" er slått ut så det er blitt virkelig bra.Her hjemme holder vi også på med påbygging men det har i det siste stått litt stille på grunn av kjøkkenet hos Yvonne. I morgen skal det startes der igjen, så det blir nok bra.Badet er så godt som ferdig, det mangler bare å liste inn vinduet og sette inn skyvedør som ligger ferdig og venter.Soverummet er også "nesten" ferdig. Der mangler det parkett og tapetsering + noe småtteri. I løpet av uken blir det nok ferdig der også. Sverre har en veldig flink snekker som medhjelper eller som sjef, kan vi heller si.Nå er det nok skryt om hvor flinke vi har vøri(fikk ikke til ae). Hvis jeg får det til kan jeg prøve å sende noen bilder. Ha ha Det der hørtes veldig flott ut.Så vil jeg få ønske dere alt godt fremover og ser frem til å høre fra dere igjen.PS. Jeg har ikke brukt maskinen på minst 2 måneder!Mange hilsener fra Kirsten og fra Sverre naturligvis Ha det !!!
    page tag? Tab Control To Open When Record Selected isoQKirstenLanggErd
• 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? Tab Control To Open When Record Selected 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? Tab Control To Open When Record Selected UtfBQhyaXM
• Need Help With Form
  • On my form, I want to show transmission information if the account has a transmission. I am new at this. The transmission is a Yes / No field on the table; the transmission details are in a separate table. I only want the information to appear if the account has a transmission associated with it. I tried a subform, but it appears whether the transmission is checked or not. Can someone help?Thanks.
    page tag? Tab Control To Open When Record Selected UtfBbGFkeWxsYnVn
• Date Diff Issue
  • Hello,Can anyone help me with my issues. I have a form that calculates a date based on the end user date input. If the the user enters 11/01/09 the formula captures 10/31/08. If the User Enter 11/30/09 the it will also capture 10/31/09. What I need is the following. If the user enter 11/01/09 then the begin date should be 10/31/09. If the user enters 11/30/09 then the begin date should 11/01/08.My current formula is as follows: =DateSerial(Year([txtEndDate]),Month([txtEndDate])-12,0)Please help
    page tag? Tab Control To Open When Record Selected UtfBSml
• Query In Excel
  • Hi,I have list of list of around 5000 companies, but in that, companies are repeated. How do I delete the repeated companies?Sorting will not work in this.Regards,Ashwini
    page tag? Tab Control To Open When Record Selected UtfBQXNodluaQ
• Time Calc
  • I am trying to do a time calculation. Here is the scenario. A call comes in at 4pm and there is a 4 hr turnaround time to respond, business hours. The Work hrs are from 8am-6pm. I need to show the 2 hrs from day one and the number of hours on day two. I have a [calltime] field and a [contacttime] field. Also, we have to take into account if the call came in on Friday so the remaining hrs should be reflected for Monday. Can anyone help me with this?-- Jonathan
    page tag? Tab Control To Open When Record Selected UtfBSmuYXRoYW
• Hello
  • ðÒÉ×ÅÔ ×ÓÅÍ!!!!
    page tag? Tab Control To Open When Record Selected giust
• Vous Inquiete Ses Pas Lune Que Pete
  • 
    page tag? Tab Control To Open When Record Selected fabien carpignano
• Import *.Qif File Into Access
  • Does anyone know how can I import a qif file (old Quicken format for bank statements, which is the one still used from my online bank) into an MS Access table?I have some knowledge of VBA, so I believe I could write the code to get it done but I imagine something already exits. (Althought Goggleing it gave no results).Thanks in advance.Alberto
    page tag? Tab Control To Open When Record Selected Alberto Comino
• 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? Tab Control To Open When Record Selected UtfBVldN
• Disable Filed Condition
  • Hi, I want to disable the field depens on other field input as below:data 1 data2A Enable the field for inputB Enable the field for inputC Disable the file for inputI try below only work for condition either one in data1Me.data2.Enabled = (Me.status = "A")Below is errorMe.data2.Enabled = (Me.status = "A" or "B")RegardsTom
    page tag? Tab Control To Open When Record Selected UtfBdGt
• 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? Tab Control To Open When Record Selected UtfBbGjaVkIHZpaFz
• 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? Tab Control To Open When Record Selected frank
• Help With Date Difference Expression
  • Good morning,Based on the following:Lost Days = DateDiff("d",Nz([MyLostDaysBeginDate]),Nz([MyLostDaysEndDate]))Restricted Days = DateDiff("d",Nz([MyRestrictedDaysBeginDate]),Nz([MyRestrictedDaysEndDate]))I need an expression that will subtract the Lost Days from the Restricted Days, when the Lost Days date range is the same (or between) as the Restricted Days date range. This will yield total Restricted Days.Example:Restricted Days were incurred from 02/01/09 to 03/01/09 and Lost Days were incurred from 01/01/09 to 02/15/09. The overlap occurs from 02/01/09 to 02/15/09.How can arrive at the Total Restricted Days?Thanks in advance for your help,Rene
    page tag? Tab Control To Open When Record Selected UtfBUmVuZQ
• Why Does A Record-Locking File Remain After I Close Database?
  • When I close my database, sometimes a record-locking file remains. This forces me to copy the database to another folder to continue my editing. The record-locking file, (64KB) remains even if I delete my original .mdb. What can I do to stop this from happening?
    page tag? Tab Control To Open When Record Selected UtfBdZchhds
• Access 2007 Ribbon
  • I've just upgraded from 2003 to 2007 so still finding my feet. i have created a new ribbon using IDBE Ribbon Creator. All works well.using Acess Options - Current Database - Ribbon and toolbar optionsi have seleted my new ribbon in ribbon name and deselected allow full menuswhen i open my database, i get my tabs, and the home and acrobat tabs. how do i hide the home and acrobat tabs so only my new tab is displayed.
    page tag? Tab Control To Open When Record Selected UtfBURSms
• Create A Specific List
  • Access 2003Is there a way that I can select specific records from a database to print out specific columns for those records?As an example, I have a database of restaurants. I want to select certain restaurants in that database to print out on a sheet of paper for a friend.-- Thank you in advance for your support and suggestions,HankL
    page tag? Tab Control To Open When Record Selected HankL
• 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? Tab Control To Open When Record Selected UtfBYmcx
• Forms And Subforms
  • I have a requsition form that contains 2 subforms.Main form - info for departments for requsition tableSubform1 - info identifying who,when,etc for requsition tableSubform2 - Info on ordered items for requsition tableEach time I click to enter a new item on subform2 it is save to therequsition table as a new record. Can I save certain info from themain form and the subform1 at the same time so each record saved whenI click to enter a new item on subform2 it contains info that infoalso? As an example, the main for contains cost code field that tellswhat budget is charged, subform1 contains the workorder number, dateordered, and date filled. All this info is needed for a monthlybilling report.
    page tag? Tab Control To Open When Record Selected Hubbymax
• Charts From Select Query - Fields Not Recognized
  • When using a select query as the source for a chart I am getting an error that the date ranges are not recognized by "jet". I haven't a clue as to what that means. The criteria for the dates are sourced from two unbound text fields on a form that default to the first and last day of the current month respectivel. Each is formatted as "mm/dd"yy". The criteria in the query for the field "main!date" is "between forms!formname!sdate and forms!formname!edate". "sdate" and "edate" are the names of the unbound text fields. To get around this I changed the select query to a mktable query and use the table as the source for the chart. The table which is deleted and refreshed when the database is open is causing more annoynaces. I have no desire whatsoever to maintain this method of creating the charts. Any assistance in making the charts to function as intended with a select query is much appreciated. If I must however use the mktable solution then I'd appreciate some help forcing the macro to continue on if the table it's looking to delete doesn't exist. Thanks,Shane
    page tag? Tab Control To Open When Record Selected UtfBchhbmU
• Datediff Error Calculating Time If Date Closed Is Blank
  • I am using the following formula to calulate the number days between creation date & closing date.DaysOpen: (DateDiff("d",CDate([...DATE_CREAT]),CDate([...DATE_CLS])))It works well as long as the both dates are complete. However, there are times when some items have not yet been closed so the field is blank. In this case it returns the following error "#Error" I need to get rid of this error message and replace it with 0. Any ideas??-- pcover
    page tag? Tab Control To Open When Record Selected UtfBcGNvdmVy
• Upgrade To 2007
  • Is it possible to upgrade directly from Access 1997 to Access 2007? I suspect not. What procedure would be involved in transferring my data from 1997 to Microsoft Office 2007 which has Access 2007?-- betty
    page tag? Tab Control To Open When Record Selected UtfBYmVdHk
• Resize Form Controls?
  • Can you resize a control (field) on the form and move it independently of the others wherever you want to on the form? I want to place the First and Last Name fields next to each other and the address right below. I also want to group some Medical information on the right side of the form independently. All the controls seem to resize all together. I see the anchoring will move a field up or down, but not with the freedom I'd like to use.
    page tag? Tab Control To Open When Record Selected UtfBdChLnNtaXRo