Search results

Hi, Richie! I think you can use events on form to be used for your porpose. E.g. OnClose event of the form you can assign the code sequence that saves your record into db. Krava

Hi, Zinemon! I only was not sure if I cought your problem correctly. Anyhow, I will try to explain my idea in detail: If you have main form, on that form ComboBox, this ComboBox is independent object on the form. So if you set up RowSource for the CB (ComboBox) that could be some table/query...

HI, Chris! There are a few methods possible. E.g.: 1) If your main form's record source is the table you want to write the calculated value into, it is quite simple: On some CommandButton (named e.g. "Save Totals") click you can write code...

Hi, Skerdi! Sorry for my poor explanation. Basically, you are right. Yes, teh HyperlingAddress property will be change every time the CurrentRecord will be changed, means during event OnCurrent. You have to read the stored path from your current record's field (Named PATH) and to make...

Hi, Mark! you can use a select query where you set up a criteria for TargetDate field e.g. <Date(), or you can also use the function DateDiff, it depends of the format of TargetDate field. Krava

Hi, Zinemon! I suppose it is not working because there is probably missing one thing- and it is that after you select one desired value from the list of combobox, your cursor on the main form should be probably moved to the record that belongs to your selection. E.g.- in combobox you have only...

Hi, Skerdi! If I understood correctly your problem, I would do following (as I have done before in many different kinds of docs): 1) I would create CommandButton1 (you can name it different name). 2) On Current event of the Form I would Me.CommandButton1.HyperlingAddress="Path to the physical...

Hi! What about "Me.AllowFilters=False" put in OnLoad of form? Krava

Hi, Folks! Well, I has been long time since I have attended this forum, I was on different projects. anyhow, I am back with one problem. I want to display some events of time intervals in grapgical form. I mean if I have Event 1 starting at 8:00 o'clock and ending at 10:00, the Event 2 starting...

Try select query, then sum (grouping), select both fields, Identity setup=GroupBy, Value setup=Max. Krava

Hi, Leong! Your combo box returns the value of ID, not the name (String). Because in the property of combobox you can see the Bound columns is No.1, means ID. So I have changed the criteria of your query, selecting byy ID. Krava

Hi, robin123! Yes, of course. You can create unbound form, means no data source. You can create as mana as you need of text fields, also unbound. You only give them some resonable names to help you further. Like DateStart, DateEnd, DateOfInvoice atc. Then "OpenReport" and "Exit" button on the...

theSizz! I am not sure what the problem could cause this situation, probably installation of Office. Anyhow, you can use any picture to your command button, when you go to command button properties, item "Picture" and then browse. So you can take the picture from the PC that it has all the...

HI, aldeb! I am not quite sure if you can use TOP 10 in crosstab query. What I would do is very primitive- I would create a new SELCT query based on crosstab query with using SELECT TOP 10 from crosstabquery.......ORDER BY total field. Krava

You are very welcome! Good luck!

Hi! I did a few things: 1) I have changed the data source for your list box- I have added ID field 2) I have changed the Number of columns of list box to 2 3) I have setup column widths to 0;10cm to hide the first column (ID) 4) Then the list box returns the value of ID that is the number, not...

Chrisabb! There is no attached documen. Krava

Robin123! For this case of - let say multiple data entered by user I would recommend to do it a different way. Becaus ethe mian disadvantage of the last solution is that if user makes mistake by entering one of the 6 parameters, there is no way back (known for me) to correct it. User has to go...

Hi, Keith! Try to open the properties of your Image control, choose the item "Size Style" - sorry I do not know the exact translate to EN, it is th fourth item in All properties, then change it to "Keep proportions" or something like that. Krava

Hi, rizzir! You can use Update query. Select your table for the query, then you choose the field you want to update and then, into "Update into" box you enter the value, means "Yes". Krava