Search results

Thanks. Works as i planned! Thanks for the help.

Hello. I just want to ask if this is possible. I have made a foodordering system, wich mean that people can order their food thru a form. The latest ordertime is 09.00. So my question is if it's possible to lock a form during a timeperiod? Lets say that the form is locked between 09.00...

Hello. I have a report made from a query wich ask... What year i want to see and what week. Works just fine. Now im trying to find out if its possible to make a sum ofthe year? At the moment i have made a subreport wich sum the year but the problem is that it sum everything....(lets say i...

Hi. This is the Rowsource that goes to the combobox. The first is the row of ID. Virkeskod: Inkommande_träslag_TBL!Träslagskod_ink & Inkommande_tjocklek_TBL!Tjocklekkod_ink & Inkommande_bredd_TBL!Breddkod_ink & Inkommande_kvalite_utförande_TBL!Kvalitekod_utförande_ink The macro is the...

file Here is maybe a better explanation. At least i hope so.

Hello. I have trouble with updating a combobox in a subform. I hace combined 3 columns into one in a table. Like this.......... Help:[1]&[2]&[3] I have a form with a subform where this ciombobox are. If i want to make a new "Help" i open Changeform. The problem is when a close this form...

Hello maybe this has been up here earlier but i couldnt find any about this so i ask. I have a subreport with dates and customer and what they brought. In headreport i have grouped the subreport daily. The subreport is "summed" in the reportfoot. What i need is to sum the subreport in the...

Must be possible Hi again. If i have a listbox with 2 columns and one is a yes/no column. in the listbox it shows like 0 and -1. Somehow it must be possible to make the column to show the text instead (YES OR NO) Maybe im wrong but i hope its possible. Anyone who can give me a...

Hello. Is it possible to change a value in a listbox? I have a column in a listbox refering to a yes/no. In the listbox it shows as 0 -1. Is it possible to make it showin yes or no instead? Matt

What i want is this. In as report i have 3 fields. Field1.....Hello Field2.....Bye Field3.....Yes/No I want to hide Field2 if Field3 is true. if Field3 is false then i want to hide Field1

Maybe this have been upp before. I am trying to hide a field in a report if anothe field is true. I get value is missing by this code. Test_ink is an yes/no Anyone who se whats wrong? I can use this in forms with success but not in reports. Matt Private Sub Report_Open(Cancel As Integer)...

Hello. I dont know if this is possible but i hope. I have transports. transport one is based on volume. Ex to destination 1 it costs 12 euro/m3 transport two is a fixed price. Ex to destination 4 it cost 100 euro My problem is that i want to get the total sum in to the query. I cant use...

Its not helping Hi. That step am i thru. The code get the same answer as i get. january in small letters. It dont get the J capital as January. Matt

Hello. I have a Date field wich i have generated to month in a question. I use this in a report but then i get february. How can i do to change so i get capital letter like February? Can anyone give me advice? Matt

You are a hero! Thanks for your patience! Mattias:):D

Done that. Sorry...feel like a pain in the ass at you. :(

Trying and trying. Have read the repport several time to see if i have write correctly. I only get #Name? as answer when i try the report.

Here i go again. I have succeeded so far that i get a zero result if there are no posts. But when there is posts then i get the text "Sum_incoming" and not the sumary of the values. :confused:

Hmmmm It is nearly right. If its no data in a week then i get 0 thats ok. But now is the problem thé other way. If i have data in one week then i get the answer #Name?? instead of the correct amount.

Getting closer to the solution. Just some "Rookie question. =IIf([SubReportName].[Report].[HasData],"SummedSubTextboxName",0) =IIf([Incoming_sub].[Report].[HasData],"Sum_incoming",0) Is this a correct understanding to your code? Thanks for your help!!