Help Creating Form

I have 5 tables: Manufacturers, Products, Brands, Varieties, Sizes. I would like a combobox Manufacturer that would filter a Products combobox that would in turn filter a Brands combobox. After selecting a Brand from the Brand combobox, I need to enter several Varieties for each Brand and several Sizes (Size, Unit, Pkg) for each Variety. Please help. I am new to this. I have the relations set in the order that the tables appear on the 1st line of this post.

Form Combo Box Causes Query Error Message

Using Access 2007, I created two similar combo boxes, using the control wizard for each form, in design view, one for each of two separate databases. For one database it presents no problem at all. But for the other, when I create a query, initially the query displays during the creation process. However, every time I try to re-open the query, it re-opens and displays the correct data, BUT only after I close an error message box that always pops up. The error message says: "An invalid condition was encountered by Access due to a value that you entered for a field or table property. 

Selecting multiple criteria in a report in Acc 2007 using a form

How can I select multiple criteria using a form to generate a report in Access 2007. -- Lady_Dee

Back End on NAS Device

Repost - Access 2007 split FE/BE, each user has their own FE. Combination of TS and local LAN users. System worked fine when the BE was on the server. A few hours after client moved it to a NAS device, the BE corrupted. In searching, I can find very little relating to Access back end and NAS. Does anyone know of any issues with locating an Access BE on a NAS device? -- AG Email: npATadhdataDOTcom

Checkbox will not check

I have a continuous form based on a multi-table query. Tables (joined fields) (other fields used by the query) TrackingNumbers (OrderID) (TrackingNumber, FreightAmt, Paid) Orders (OrderID, CustomerID, FreightID) (OrderDate) Customer (CustomerID) (CustomerName, City) Freight (FreightID) (FreightName) Sorted by FreightName, OrderDate Paid = 0 The form is to be used when I receive bills from various freight companies... allowing me to verify charges and check them off when I pay them. The form lists all orders with unpaid freight bills with this information: FreightName-OrderID-

PLEASE PLEASE PLEASE HELP

Please can someone help me immediatly. I have a form with a field on it that is attached to a table. when a agent creats a audit they click on this drop list to show all the groups in this table and they select one. The problem is if the group is not in the table they put a new group # in the field and it takes. This cause the report to not populate because it is not finding the group #. My questio is how can I set the field so if an input is made that does not match the table that field is pointing to it rejects the data and prompt the user that this id is not found. Pleas

numerical summation to passed from sub to main form

I have a subform that tracks payments. I have a text box in the form footer that calculates total payments. I need that total amount of payment passed to the main form, so that I can then calculate a "balance due" from Total Owed - Total Paid [which I do know how to do]. Thanks

Filter Form doesn't close

Hi all. I have an Access 2007 form with a command button that does this on the OnClick event: DoCmd.RunCommand acCmdAdvFilterSort The filtering form opens correctly and I'm able to specify my criteria. If I right click and choose Apply Filter/Sort, the filtering works BUT the filter form doesn't close. Instead, my Access 2007 form appears in front of it and gets the focus but the filtering form stays open. I'm using a customized ribbon and have tried two other ways to accomplish this. The first is: idMso = "ApplyFilter" The second is a m

duplicate check before report runs

Hi, I have a form that has been added to over time. The latest addition is a check box that generates a letter to the GP if a patient is on a particular drug (user activated). A 2nd table (tblPPIreview) has been set up to hold the information returned via that letter. (It is faxed out and faxed back). What I want to do is this. When the user checks the box for the letter, it 'sends' the patient's personal unique identifier (NHS number) to the 2nd table so that it is recorded in that table that a letter was sent. However, if the NHS number already exists a message pops up

primary key duplicate record is not incremental

Hi, When I duplicate a record in a form using a command button, the primary key of the newly created record does not continue from the last one. For example, if the last one is 1410, and I want to duplicate record 1157, the new one is a random number (i.e., 545687). Any idea how to fix this? cheers, Gonzalo

Delay in an action for certain time and then let it execute

How do i delay an action for certain time and then let it execute automatically. For an example i want some action to execute and then need to close the form after 2 Minute time. How do this 2 min delay can be imposed?

Restricting SubForm to One Record Entry Per Parent: Access 2007

Hello All, I have a one-to-one relationship between two table. I have successfully added the subform, but I get the option to add additional child records in the Datasheet View. This means that when a user tabs to the next row and enters data they get an error--and they should. Question: How do I restrict the subform to show only one row in Datasheet View? I hope I was clear. Feel free to ask for clarification. Thank you in advance for your assistance.

Access 2007 Fonts

In AC 2007 when I open the drop down for the fonts I see a few fonts that aren't in the system fonts in my Control Panel. There are 8 of them and are named: Z@R32AF with a variation after the R. I didn't name all of them but the extension and the Z@R are in all the names. Again these font names do not show up in control panel|fonts. Any idea how these fonts got into access? Thanks, James

Embedded Acrobat Viewer

I am trying to embed Acrobat Viewer ActiveX control into Access Form. I have done it before on different forms and it works OK. But now, in the new form that I am working on now, the PDF file is not showing up. No errors, but no image either. Any thoughts?

Error 3075

I’ve looked at nearly every post and can’t find an answer so many thanks for any help. I have a value for FloorProgCriteriaID that’s populated via this code on a form open event: Me.FloorProgCriteriaID = _ [Forms]![frmSelectFloorProgCriteria] _ ![lstFloorProgCriteria] Can someone please help me figure out why I’m getting a run-time 3075 syntax error (missing operator) in query expression '[AuditID] = 12 And [FloorProgCriteriaID] = And [AuditorID] = 'T5925MS'' (I didn’t leave out the value after [FloorProgCriteriaID]. The value returned is Null based on the Debugger). Private

Currency Field

I am using Access 2003. I have a form with a currency field that has 5 decimal points. This field rounds up when I do not want it to. Ex: I put in $0.15768 and get $0.15770. I trield to expand the field to 6 decimal points but it still rounded up. How do I get this field to accept just the currency I put it and not round up? I would appreciate any help you can give me. Aurora

List Box Click Event Anomaly.

Access 2003. I have a form with a List Box control, the Row Source is linked to a query to show a list of client addreses. The List Box control is third in the Tab order so the user will press the TAB key and move the cursor to the List Box, use the Up and Down arrow keys on the keyboard to select a record in the list and then click the selected record to display some information about the client. The problem is that as soon as they press an arrow key, the List Box Click event is triggered and they get the first client in the list instead of the one they want. This seems to be a f

Name saving as ID

I'm currently utilizing a combo box in my main form to select employee names from a linked table. When the record is saved into the database table, it shows the ID number from the table instead of the name from the field. How would I correct this? Thanks!

Hyperlinks in Access 2007 Rich Text

I love the HTML-based rich text in Access 2007, especially now there's a hotfix so you can edit rich text in subforms. It's so much less hassle than ActiveX rich text controls, or embedded Word documents. However, I have a problem which has been bugging me for days. If I want a clickable hyperlink in a rich text field, all is well if I simply type the URL into the field e.g. "www.microsoft.com". But, there doesn't seem to be any way of displaying the hyperlink as a word or phrase rather than the URL e.g. if I wanted it to show as something like this: "For more information

how to put in a look up

I would like a look up or whatever in my data base. I have many unusual names in the data base and it is hard to come up with the correct spelling of a name. I would like to just be able to enter the first letter of the last name and have all names starting with that letter come up along with the ID number I have assigned. I do not have much programing knowledge so it should be easy to do. I am using Office Professional 2007. Thank you Foster1

Does any one know of a template for purchases, business card siz

I would like to be able to have a business card size card that I can punch the amount of purchase for my customers. After they make a certain amount of purchases I would collect them and they would receive a discount on their next purchase or a free item.

Error 13 Type Mismatch

Need help solving a type mismatch error on the following code: Many thanks! Private Sub Form_BeforeUpdate(Cancel As Integer) 'Limits the number of records allowed 'based on the field FloorProgMaxObservations If DCount("*", "tblFloorProgAudit", "[AuditID] = _ " & Me.AuditID.Value & "" And _ "[FloorProgCriteriaID] = " & _ Me.FloorProgCriteriaID.Value & "" And _ "[AuditorID] = '" & Me.AuditorID.Value & "'") = _ Me.FloorProgMaxObservations.Value Then MsgBox "You're attempting to exeed the maximum _ number o

pivot table calculations

I have not done much in pivot tables. But I have designed a pivot table form that does all I need except for the last step - creating a column to show a net amount. That is, I need to subtract……. I have the sum of expiring Leases, that’s all I need. I do not care about the type of lease. For beginning leases, I have sums for three types – new, renewal or extension – and a total for all beginning leases. I need to know a net number for each month – number of all beginning leases minus the total of all expiring leases. I can’t figure out how to get that figure in the pivot t

Application Very Slow

I am using Access 2003 FE & BE application. My BE is in the server and about 15 Nos of simultanious users accessing the database with FE (MDE format) application which is on there own Pc's. For almost all recordset operations I have used "db.OpenRecordset("", dbOpenDynaset)" type in my FE application. If only one user is using the application, then it is very fast and just after any of other user logged on to the system then the whole application performance dropping down considerably. And also two users are not using the same form as well as not using the same tables (Directly) . I wan

Combining forms with separate tab controls

Hi there I have created two forms. Each form contains a tab control. I would like to combine these two forms and incorporate information from both tab controls. What is the easiest way to complete this task? I really don't want to recreate the forms. Thank you in advance for your help.

On Cursor Hover Quastion

Access 2007 sp2 I have command button's Cursor On Hover property set to Hyperlink Hand. On the same form I have a date field. After choosing a date from the date picker and then move the mouse pointer over the command button the hyperlink hand doesn't appear. In other words the mouse pointer remains as a pointer (default), it doesn't change to the hyperlink hand. Any idea why this occurs? Thanks, James

Access 2007 scrolling with Left mouse button

Hi, all. I have an Access application written in Access 2003 that we are now testing with Access 2007. When using Access 2003, the users used to be able to scroll through records displayed on a form by positioning the cursor on top of a VCR button and holding down the left mouse button. People with external mice could also cause the same scrolling by using their mouse wheel. Neither of these behaviors happen when the application is run using Access 2007. After reading a number of posts about changing the behavior of the mouse WHEEL when using Access 2007 so it mimics the scrollin

Look up field

I am using Access 2003 I have a form created in which I have to type descriptions of our ball products. Ex: 0.75mm Tungsten Carbide, or 0.33mm Ceramic, or 1.25mm Plastic etc. I am trying to create a field where I would only have to type the number - 0.75, or 0.33 or 1.25 - and be able to select the material to go with the size. I made a Look up data base for the description field. But after I type the number and select the description - the material over writes the number. Leaving me with only the material and no size. Can anyone help me figure out how to do this? I have a

Force Record in Subform

I have a main form (F_Ticket) and a subform (F_Ticket_Sub). A user enters general ticket info in the F_Ticket form then line item detail in the F_Ticket_Sub form. My problem is that I want to enforce that at least one line item is entered in the F_Ticket_Sub form. If not I dont want a new record created in the main form - because ther should never be a new record in the main form without at least one record in the subform that relates. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-forms/201003/1

Sorting in Pivot Charts

I'm using Access 2003 & am trying to sort in a Pivot Chart. I have a single series & I'm trying to sort by the qty of that series. Thanks much in advance, M.C.

Re-Link backend with ini file

OK I've been playing around with this for a couple of days now and have found a few suggestions as to how to do it. But I still can't get it to work. Basically, I have a Frontend called FEApp.mde and a file called DataPath.ini in one folder and a Backend called BEdata.mdb on another shared computer. The DataPath.ini file and has only one line in it. \\PC1234\SharedDocs\BEdata.mdb On another forum, someone posted a suggestion to have this code in the Front End Dim strFile As String Dim intFile As Integer strFile = App.Path & "\DataPath.ini"

Cross Tab Query

I have a access database with SQL backend. The table labproofs has charges listed by report date, with the below query, I can run a cross tabquery with the end date selected from a form (monthly report), and it gives me the 12 month data from the end date selected. However, the problem I face is for example if the end date selected is feb 28th, I get the data for previous months as Jan 28, Dec 28, Nov 28 ......, I want data for the month end numbers like feb 28, Jan 31, Dec 31....., I am not sure what I am doing wrong here. Please help. Gmen PARAMETERS [Forms]![Monthly Reports]

Show complete record in continuous forms

I have had the same issue for a while but don't know if there can be anything done about it. Continous forms have a sloppy look when when you have too many records to show on one page. Is there any kind of coding that can be done to give functionality like a report has where records stay together. I know reports and forms are apples and oranges but just wondering if there is a way to give a form a better look and not show half of a record at the bottom when it is opened up. I'm guessing not but if there are any ideas... Thanks. -- Message posted via http://www.accessmonster.com

Confusion with forms and related subforms

Hello, I'm trying to figure out the concept of embedding subforms into main forms. I have main tables, 4 junction tables, and a few look-up tables (not all look-ups are listed below). If I'm reading it correctly, the junction tables which relate to the main tables should be in the form of a subform placed within the main form they relate to? I'm lost on the fact that I believe I have a subform which appears should be on another subform which should then be on a form. If this is correct, the form looks extremely busy and not user friendly, and just plain incorrect. Is it t

Disallow field sorting by users

I'm using Access 2007. My subform is shown in datasheet view. The field captions on the datasheet contains the standrd Access 2007 dropdown option to sort on the field but I want to disable this and kind cannot find a way to do so. I got rid of the filter option on that dropdown by seting the Allow Filters property to false but I can't find a similar property to disallow sorting. Any ideas?

How do I add a record counter to my form

I would like to add my own record counter, like "Record # of #", to my form. How can I do this?

Stop advancing in form with the "next" arrow at end of "list"

I have an editable form for users where they can query by date, etc. However, the next entry arrow allows them to advance beyond the result. For example, if their query resulted in 1 of 4, they can still click to 5, 6, and so on which only adds blank lines to the database table. How do I set this to stop at the last entry of their original query?

Sorting Buttons (VBA)

I am struggling with creating commdand buttons for sorting on a field. Here are the codes in the two buttons: ascending sort button... Me.OrderBy = "[Vendor_JE]" Me.OrderByOn = True descending sort button... Me.OrderBy = "[Vendor_JE]Desc" Me.OrderByOn = True The ascending button seems to work. My question is why isn't the descending button working and how to do clear out the OrderBy in the forms property. Thanks! -- Message posted via http://www.accessmonster.com

how to put photos in Microsoft Access Form

I've noticed that the questions asked in the "Community" are from 2005 - 2007. Yet none is any help to me and I've tried almost all of them. I have Access 2003. is there any updates putting photos in Access 2003 form. Also, I posted my question yesterday and it's not in the community list. What happened to it. How am I to know when my question will be answered. Will I get an e-mail that someone has looked at what I've posted and give me some help. Please let me know Helen

Help with requery/update

I have a form called frmAuthorization with a combo box drop down menu called RNAsssor. I want to send an email to the Assessor chosen in the combo box with a report attached containing the data just entered on the form. I have a macro set up to send the report in an email. In the On Exit event of the combo box I have: DoCmd.Requery DoCmd.RunMacro "mcrInitialAssessment.Initial" The problem is when I exit the combo box, it does the requery and all of the data disappears from the form, and the email is not sent. When I take the DoCmd.Requery out of the code, the email an

list attachments in a form or record

I have figured out how to add attachments to a record, but the default way of handling them on forms isn't the greatest. I would like to be able to have a list of the attachments directly on a form (I have a form that lists details for contacts and I would like one of the fields to be the list of attachments). I would also like the ability to select and open the attachments from the form. Is this possible? I did a quick search and haven't found any discussion that covers this. I'm using Access 2007.

Combo box help please

I have a combo box with 4 fields which is using a query made from 2 related tables. Column 0 populates the primary table and I need column 1 to populate the secondary table once selected in the form. The details from each field are located on the form (hidden with a visible field which joins columns 2&3 into one field) Is there a way to do this? Really do not want to split this down if I can help it. If I do need to split it, is there a way to select column 0 and it make the 2nd combo box only show related entries e.g Current Combo - 0=Company Name, 1=ContactID, 2=First

same subform used in two different forms

Hi Folks, Is it possible to use the same subform in two different main forms simultaneously? If it's possible, is it good practice? I can foresee that there may be problems with code, but the subform I'm thinking of is very basic. Three tables: tblFamily FamID (primary key) FamLastName tblIndividual IndID (primary key) InFamID FirstName MiddleName ....other personal data tblAddress AddressID AdFamID street city state zip Two main forms for different types of data entry frmFamily with family information on the main form and address information in the

Dificult with subform

Hello, wonderful forum, as I do not speak English, this is a machine translation of Google, I hope you understand my question. I have to make a form with a subform included. This subform would include data on the main form. The difficulty is given by the relations between the two tables Main form Table 1: Suppliers id_prov Subform Table 2: Articles id_art prov_1 prov_2 prov_3 Where the two tables are related as follows id_prov -> prov_1 -> prov_2 -> prov_3 Where any item can belong to three different suppliers. The idea is that in all the articl

How can I put photos in Microsoft Access Form

I used the information BobLarson said in putting photos in Microsoft Access Form but it's not working. My computer keeps asking for Form1, which I deleted because nothing was happening the way I wanted it to. What I would like to know is there a online video that can show how you can do this procedure. And how can I get my computer stop asking for Form1.

Tab Control

Hello, I'm using Access 2003. I have a form with a tab control. I want to have another tab control within one of the page of the main tab control. So when you go to a certain tab, I'll see 3 sub pages. Is this possible? I can't seem to drag a new tab control onto a existing page of the main tab control. Thanks

Auto Populate a Combo Box based on the user selection of another Combo Box

I have a form that has 3 Combo Boxes; 1) Personnel Number, 2) First Name, 3) Last Name. The Row Source for each Combo Box is "tblPersonnel_Number", and each Combo Box is assigned to their respective Control Source by name. When the user selects their Personnel Number I'd like the First Name, and Last Name to populate automatically. I found out how to do this by using "=Personnel_Number.column(2)" for First Name, and "=Personnel_Number.column(3) " for Last Name, but when I close the form it saves the Personnel Number into "tblPersonnel_Number" but not the First Name and Last Name. Is the

form design issues - Access2007

Hello Access 2007 here, 2 quick questions: 1) how can I manage comboboxes do NOT change background on exit? It seems that by default, once you exit the control it kind of make its background transparent, even if either backcolor or backstyle values didn't change, I ckecked. 2) I'm noticing that after starting typing in an unbound form, the labels text seems kind of bolder, not looking "regular" as when the form opened. I read some years ago something about issues regarding memory licking that can cause weird *things*. Does anyone know something more accurate? thanks, rocco

recall of infor on a form

I have created two tables: table one has basic info lname, fname, grade, student id number. Table two is an incident report form with fields: student id number, date ,grade , etc. I have a relationship from table one to to table two in a one to many relationship respectively. My user wishes to enter incidents on a form. So I created a form from table two and all works as planned. However my user would like to enter either a)student number or b) last name with out using a drop down list( long list of choices.) and then have it display both student number and last name then save

How to keep the top of the form anchored at the top

Hi there I have created a form and subform where the subform is a tab control. When I open my form, I'm at the top of the page but when I start to select any of the tabs, I'm no longer at the top of the form but am located near the bottom. How do I set it so that my form always stay at the top instead of moving around? Thank you in advance for your help