Search results

Hi, Beckie! Yes, I think. One way is: You only change your Month([Test Date]) into Year([Test Date]) & Month([Test Date]), and your criteria to Year(Date()) & Month(Date()). Hope it helps. Krava

Hi, robin123! I think the easiest way to do is to change the data source of the report slightly. I belive, the data source is table/query. So in the query you add one cutomized column, e.g:LetterDate: [Input the date of the letter], where "LetterDate" is your customized name of the field to be...

Hi, ddrew! Well, I have modified your db slightly. I have changed the data source (query) of the list box in th esearch form. I have added ArtistID and it is the first field. Then, I have extended Number of columns for list box to 7, but I have set up the columnwidth of the first one (ArtistID)...

Hi, ddrew! I think it is quite simple. In your search criteria you use "ID=" & variable. ID is Number type, your variable is String type. It wont work this way. Krava

Hi, Rheet! Sorry, I just join you conversation in late point, but I have noticed one thing that is quite important for me at your problem: The row source of the combo box on the form is the table. The bound column is No.1 (see in properties) and it is ID (number). So your selection in Combo box...

Hi, Adil! Did you solve your problem already? Krava

Hi, Michele! Try to add a new column into you query. Define your own name for the column and use this syntax (enter it into blank "Field" part of the column): MonthNo: Format(Month([DateStart]);"00"), where MonthNo is your name of the column and "DateStart" is the field name in your table...

Hi, Kev! I was fighting with similar problem and I have used simple method how to change the data source of the form/report based on query. For me it was the most reasonable solution: You can modify the Query SQL by code, so if your Query is qryTeamPickStats I would do: Dim db As Database Dim...

Hi, Josh! Well, I think it depends on the data type of the field. What is it? Anyhow, you have to format the inputted data by code/mask on your form but it also depends on th way of inputting you use. Krava

Adil! Actually I have realized that I am missing the join between those two tables. If you do not join them the query result affect all combinations of all records from both tables matching your criteria. I suppose you should try to join the tables via the Primary key fields ("client"). Krava

Hi Adil! I think the main problem would be that you are going to update multiple records, field "client" to the same value. Fiel "client" is a Primary key so it must not be the same, as it has to be unique. Krava

Hi, ngs88! I use a similar thing and I have made it simple: In the form, on event OnCurrent I setup HyperlingAddres of the button= FULL PATH to document (Path\Fielname). Then, when I click the button after selecting the item from the form, system opens the document automatically. Hope it was...

Hi, Beany! Well, maybe I did not understand your problem correctly. I ment, if you change/modify your data in the table in VBA code you should call Form_FormName.Refresh method in the code just after the sequesnco of changing/modifying the data. Krava

Have you tried Me.Refresh?

Hi, Beany! How do you make the changes in the table? By code? If yes, the I suppose Form_FormName.Refresh would help after updating the table data from the code. Regards Krava

Hi, Casmurbax! I am not sure if I undrstood correctly, but I have changed your code in Form1. Have a look if it is suitable for you. Regards Krava

Hi! Are they going to input current date and time at the moment they fill out the form? If yes, build a simple button that will fill out the desired field with now() value. Krava

Hi, Aplpapak! If I understood your problem correctly, you want to modify the data shown in your combobox. I presume that the row source of you combobox is some table/query. If yes, you do only simple thing (I think). In design mode of your form select Properties of your cmbbox, select "Row...

Hi, Pat! We recently needed to get the Form to snapshot format file. I have talked to users and I found out we can manage it a different way. Many thanks for your help anyways. Krava

Hi, Pat! I said already that it is kind of stupid question. Well, you are particulary right. I am trying to solve a different problem an it is to save a Form in SnapShot format, which works only with reports. I am not able to save a Form in snapshot format. Maybe only I do not know... The idea...