Search results

Change your Image control's "Picture Type" to Linked instead of Embedded. You can find it in the Format tab in the Properties sheets

Is there a way to find out how much space is left between the Report and the Page Footer of a report? I want to move a sub-report place in the report footer the the bottom of the page, just before the page footer and I think I could use that with the .Move method. By the way if anyone out...

Try this If OpenArgs="FilterForm1" Then Me.lstListbox=Forms!Form2!FilterFieldID Call lstListbox_Click Me.lstListbox=Forms!Form2!FilterFieldID End If I guess you have a Me.refresh or something similar in the lstListBox_Click event

Ok I've looked at you database. A few things: It's not advised to use spaces in the name of fields, name of form controls (text boxes etc) The code you posted wasn't working because the name of the field in your table is "RCB Number" and you used "RCB_Number" and the same is for your text box...

Can you give us a database copy so we can have a look? This could be a problem in your tables' relationships or some setting in a table or any other number of reasons and without having a look at it we could be going on a goose chase

What jdraw meant in that the way you use the DLookup is used to compare strings. You can search for the correct syntax to use with DLookup depending of the type of the field you want

To elaborate on jdraw's answer [CODE] If DCount("RCB_Number","tblRCB","[RCB_Number=" & Me.RCB_Number)>0 Then MsgBox "RCB Number already exists please enter a new number", , "Duplicate Value" Canclet=True Me.RCB_Number.Undo End If [/CODE] I'm taking as a fact that RCB_Number's value is a number

Use the code to test how many days have passed JHB suggested in his sample and after the given time has passed you can lock the controls in your form so the user can't edit hem

Hey there AlexN, sorry it took me this long to reply but I was away during the weekend :D I checked your sample and I didn't see any code in your form, so I assume you select what you want in the form and then run the query. I tried different combinations with selections from the form and it all...

Hey bigalpha, glad to hear you got it shorted out. About the Listbox, when I tested If OpenArgs="FilterForm1" Then Me.lstListbox=Forms!Form2!FilterFieldID Call lstListbox_Click End If On my Access it would select the appropriate record. What is your Access version?

Try using the same table in both select statement SELECT ID,Description FROM tblData UNION SELECT TOP 1 "*","ALL" FROM tblData It would help if you could provide a copy of the query in which you pass the parameter

When you scroll (either vertical or horizontal) on a datasheet it will keep scrolling till only the last record is visible and after that it display some blank space. That's the default behavior in access and I don't think that you can change that. As for the white space, I guess your are using...

I guess that in the record source of the f_filter_nycklar you've use the combo box values as conditions to display the data. If that is the case I suggest a different approach. Set the record source of f_filter_nycklar without any condition so it'll get all the data. Place the following code in...

You can change the Row Source of the combobox to include a "*" value. You can do this with a UNION query. Something like this SELECT ID,Description FROM tblData UNION SELECT TOP 1 "*","ALL" FROM tblFake This will give you a combobox with 2 columns, you can use the 1st comlun as bound and the...

The report is for Offers printed to be given to customers. It has some items with prices and the report footer shows the total cost of the Offer. The rptConditions displays different conditions for that Offer and based model for these Offers, the conditions must be placed at the bottom of the...

I check your database, you had a wrong type of relationship between the two tables. Also GovernmentRef_ID in tblApplicant is a foreign key referencing the ID of tblGovernmentRef. You can't set a default value to a foreign key because if that number doesn't exist in the referenced table you get...

In Form2 on the click event of a Button whatever you use to "click a record" in that form If CurrentProject.AllForms("Form1").IsLoaded Then DoCmd.Close acForm, "Form1" DoCmd.OpenForm "Form1", , , , , , "FilterForm1" Else DoCmd.OpenForm "Form1", , , , , , "FilterForm1" End If "FilterForm1"...

Hi again Minty, thank you very much for your suggestion. I created another group and put the rptConditions in that group's footer and it displays everything now. The problem is that it is printed before the Report footer. Is there a way to make this custom group footer print after the report...

hey Minty, unfortunately for me I can't because the conditions have to be printed on the bottom of the page. Sorry I forgot to mention that part:p

i know this is an old thread and I don't know if you found a solution,if yes please mark it as Solved, but just in case. Try using the report's Open event instead. Check if the path for the image is empty and if it is set the Visible value of the image control to false