Search results

Hi Paul I don't think you can change the caption background colour or the text/foreground colour on a tab control ... in fact it is the Page of the tab control that has a caption. Tabs tend to have a very bland generic colour ... pity! However, you could change the caption ... from "Click...

Hi Cheeky Yes and No ... or perhaps/probably! I don't know of a way to make a command button one form actually click another button on a different form ... and I don't think you need to do it that way. Instead the coding behind the button on form 2 can be copied across and used within the...

Hi Laocon Sorry that I confused you ... I probably assumed by your Member status, and the fact that your questions were well phrased and very specific, that you were an experienced database designer! So, you consider yourself to be a newbie and you don't start training until January ...

Hi am_sarath Unfortunately lines do not have a "Can Grow" property. You can have a border around your text boxes on a report and this (the text box) can be set to can grow and the border will naturally grow too. Apart from that you have to get into VBA coding to achieve what you want. See...

Hi shieldk I have just tried the Apostrophe code within my own database again and it works perfectly. I am sorry that you can't get it to retrieve records with apostrophes ... but I think there must be some other reason why this is the case! Good luck in your attempts at getting it to work...

Hi again First set up a table of Default Order Products -tblDefaultProduct - (this need only contain the ProductID number). These will be the six/seven products automatically added to each instance of the ForecastProductDetailsSF subform. Then create an append query (qappDefaultProduct) that...

Hi Capri I am probably stating the obvious, but you do have a combo box called SelectUID (not Combo38 or similar)? HTH Rich Gorvin

Hi linda sciallo Why not use a GroupHeader and put the contractor details in there? The two other sets of details can form two rows beneath the Group Header. HTH Rich Gorvin

Hi Scottk In the Design View for your query open up the Properties window (right click on any grey area and select properties from the context sensitive menu). Change "Unique Values" from No to Yes HTH Rich Gorvin

Hi Shieldk You could create a function to deal with Apostrophes and then call the function from your form. Here is the Apostrophe function (not something I created ... so apologies to the actual author but I cannot remeber where I found it). ----------------------------------------------...

Hi Junmart Your question is a bit vague! However here is a stab at what you might be looking for. Suppose your text box is called txtFullName and you want the variable to be two names stored elsewhere concatenated with a single space between. In your code you might have something like: Dim...

Hi Laocon Yes I am sure you could do something as you have described with a default set of products automatically generated for each subform. However, there are a couple of things to consider. First, there is the fairly obvious point that you, presumably, will be storing records with the...

Hi am_sarath You could create a report with subreports, one for each table. However, this seems unusual as usually the information displayed in a report is more than just the tables as straight tables/datasheets. Have you thought about linking/relating the data together via a query and then...

Hi Neil I am sure there is more than one way to do this ... but my suggestion is through a query. In this query you will obviously need the three fields concerned - Price, Quantity and your MinimumValue. Create a new column in the query called SubTotal, and create an expression/calculated...

Hi David Presumably a client can have multiple plant types (so a "one client to many plants relationship" is required) and also a plant type can be supplied to many clients ( so a "one plant type to many clients relationship" is needed). This means you require a many to many relationship...

Hi Harrisw Are the fields/columns BI Schs and CS schs Yes/No (True/False) fields? I would guess so ... and in that case it is understandable why you get a negative value, once you are aware of the fact that Access stores : Yes as -1 No as 0 So if you sum 10 rows that have a value of -1...

Hi Rob In your first row for the query criteria you presumably have something like: Not "Nursing Midwifery" At the moment, and quite correctly, Access is eliminating any records that have a blank (or Null) value in the relevant. You need to add the following in the criteria row below (in the...

Hi Randix I think I get what you want to achieve - if there is some data in the memo field "lic" then the report should display "Update" in that field. When null then nothing is displayed. I think the error may be in the name of the field from your query being "lic" and your text box/memo box...

Hi Steve Subforms can be used for inputting data as well as editting and deleting data. You may need to check a few things, for example: 1. Is your subform linked to your main form using the correct foreign key/primary key? The Child/Master links should use the same field - eg. CustomerID...

Hi Timberwolf First let me say that I think it is probably better to change the name of your field from Count. "Count" is a function within Access, so like Date, Time, Now, Name etc it is probably better to avoid calling a field just this - but you could always call it txtCount. If you have...