Search results

VB runtime error 3464 marks yellow above stamement - code

Hello and thank you There's error and Vb shows an arrow in: DoCmd.OpenForm "Fr_PromStoixeia", , , sVal

Hi all, Is following wrong? a search command opens Fr_PromStoixeia and access pops up Enter parameter Value ? "Tbl_Promitheytes;promitheytesID" DoCmd.OpenForm "Fr_PromStoixeia", , , _ "[Tbl_Promitheytes;promitheytesID]=" & "'" & Me.lstSearch.Column(0) & "'"

i would like some help in an expression please: In a form, adeiesfrm, having source a table adeiestbl, and in texbox, I use an expression to calclulate remaining days of employees vacation. In my work every employee has the right of 30 days of this kind of vacation in a year, or if notspent all...

I am using Dsum to retrieve totals of empolyees holidays or vacation, and i have this table: adeiestbl Vacationid = Autonumber SurnameId = Number DateofRequest = Date/Time numberofdays = Number Starting = Date/Time TypeofHolidays = Number then in a form havind the above...

Yes it is a crosstab.. how do i use the WHERE argument of the Open Report command an example? Thank you

Hello have you took a look in my DB? Thank you

Do i have to put parameters in code?

Hello, i did upload my Db, You should go to form ypobolesfrm, type in ETOS "2011" and in MHNAS "10" do a click under SABBATA on the A4 button, it calls Qrsavvataepilogicross which is a crosstab query, to open the RptsavvataepilogicrossA4 in print preview, Under the dates, and beside...

I've updated my question as instructed. Could i be more helpfull by uploading the Db?

I have a strange problem in a crosstab report called "RptsavvataepilogicrossA4" The report uses vba code to produse labels for dates (Saturdays) employees who have worked in a month. The s[COLOR="Black"]ource is a crosstab query Qrsavvataepilogicross. Query working fine, all the Suturdays...

Thank you Bob, I upload my db,. -the form i need to have the parameters from is "ypobolesfrm" and in there are two unbound textboxes on top, named after "ΕΤΟΣ" and "ΜΗΝΑΣ" ("year" and "month") -the report which i need to work is "RptsavvataepilogicrossA4" which is called from the previous...

Thank you Bob i have tried that, setting up parameters in my select query specifically, and it is working for the query!.. but then the report doesnt show anything... When i use parameters as [forms]![ypofovelsfrm]![year] from form, in the select query also specifically in the parameters...

Thank you for your reply and yes i ve tried to do that, set the parameter from form (unbound textbox) but the code doesnt work then, maybe if i put the parameters in the code, but i dont know how to do it i am absolutelly rookie on vba

problem with vba settings please help me, i need you to see why the values in my report will not appear when i enter parameters from form in the way: [Forms]![ypobolesfrm]![year] on my crosstab query, while report works when i put the parameters like "2011" (numbers) in the same query.. code...

I have this report based on Crosstab query, named "Rptsavvataepilogicross", in that query five (5) fields are representing dates (Saturdays) over each month, and take values either "1" or null, depending on weather some employee has worked over Saturday. In the Report those five fields are...

i need help please, i use a report to display values depending on work type of employees for every day of each month like 1,2,3,..31 The query suporting that report is crosstab query and the values displayed in the report is "ΧΡ ΚΥΡΙΑΚΗΣ" or "NYXTA" or ""ΧΡ ΚΥΡΙΑΚΗΣ" or "ΑΡΓΙΑ". I need to have...

Thank you so much solved great with your help!

Thank you for replying I looked over for query properties where is that ?

Please help me: my db permits duplicates shifts for employees that work same workday.. And had to be like that since it has started. Problem is that in a query to display monthly needed values I need to count only per once in a day when a person has worked on a Holyday (day) or Sunday maybe a...