Recent content by goldmedallist

Followup question on Date SQL Hi all, I am thinking of having a drop down box that has the month and years listed ie Jan 2004, Feb 2004 etc. Is there a way to have those values extracted from a Calendar like control? I have tried the Calender Control 10.0 but it has also the date which I do...

Ok, somehow I managed to get around the problem by doing from scratch again...I am not sure why. But thanks anyway!

Hi Peter, Thanks for the reply. I reversed the order and it doesnt give me that error. However it does give me the error instead "The record source "FROM..." on this form or report does not exist." This is really wierd, since I thought my Forms!AllData.RecordSource is supposed to be...

I was working along a code that seemed to work fine until all of a sudden, the next time I tried it it, it doesnt. It is a simple code really as below which is giong to be the foundation for a selection followed by SQL input into the record source of another form to generate results. I get the...

I am trying to generate a query that shows the data that the user indicates via check boxes. What I did is a form (GenerateQuery) which lists down over 30 fields with their respective checkbox. When the query is run, it will open up another form (All details) with the massive froms in DS...

Thanks Pat, it was helpful to know the rationale about the referential integrity part. It now all makes sense why I cant move off the control of one form into a subform. I guess I will use the Before update for each record for the time being and attempt the shadow tables when I have the time...

I found this thread as I was searching for an answer and followed roughly the instructions listed here but came across some roadblocks I have 2subforms in 1 main forms. And I would like to delay all updates until I use the custom save button to save all 3 records. What I tried doing is as...

Hey ddrew, What is the error message or what is the result giving you? It should be FROM table since after all your data in the forms are all populated from the same table

I am hazarding a guess but since I presume all your CR2 are from the same table? If so then a query should work as below SELECT SUM(CR2) FROM "name of your table" Hope this helps somewhat

Thanks very much SJ, It wasnt until I read your reply that I realised I totally forgot about the form's Before update property. All along I tried Before Update for every single control and that means I had to click yes/no multiple times just to get through a form and that was the reason I...

My question is essentially about the saving of information into the underlying database. I have been searching the forums and havent had any luck in finding what I wanted. There were a number of similar threads but I couldnt find any replies which could really point me in the right direction...

Dear all My inquiries is 2 fold 1) The first relates to refreshing of the data. What I have now is a main form and a combo box control that generates the list of values based on the current data shown on the main form. In more elaborate terms, I have a Main Client Form, and a Fee tracking...

That happens to me too, but I think there would be a need to refresh the form for it to take effect. I tried using the refresh button and it works in some cases. I am not sure whether it works everytime though On a slightly seperate note, how do you prevent the data from being recorded into...

Hello MStef and Bryan, Thank you very much for both your assistance It works perfectly! Warm regards

I am trying to write a query to extract the first 3 characters from a character string but have no idea where to start since we usually use Select "field" etc etc Example, for a Code ACC01, the query result should give ACC Would appeciated any guidance. Thank! TK