Search results

Hello. My mind i stuck with this problem wich i hope someone easily could give me a hint how to make it possible? :banghead: I have two unbound tables. One table contents From........ Too.......... Distance... The other table contents Company.. Min_km.... Hi_km...

Hello. Probably has this issue been up before bnut cant find it. We have upgraded our system to access 2010 and there im stuck with a problem. I have a form with a listbox. i want to make a choice in the listbox and click open. Then all the information about the person comes up in a new...

Hello. I know this issue has been up here quit often. Have tried to search for an answer and have come a bit forward to my solution. But not all the way. Here is my issue.....: I would like to have a sequent ordering id but for 2 companies. like this. company A has an ordering id...

Hello. I wonder if this is possible? I have a form with tabs. In the first tab i have a listbox. What i want to make is a headline in the form by the value i choose in the listbox. Thanks for help and i hope i explained well enough. Matt

Hi. I would like to ask if its possible to close down a DB if it hasnt been used for 10 minutes? I have a db with many users on different computers. They forgett to shut down the db when they dont use it. So would it be possible to automaticlu shut down the db on a computer if it has been...

Hello. I just want to ask if it is possible to make so that the user only can make a order if the date is happening during next week? I have made a form where the user can make an order for the next week. I want to make it impossible to make posts that dont have a date that comes during...

Hello. I have made a table wich makes 3 fields to one index. you cant write the same text twice in these without an error saying there are aldready one of these in the database. I wonder if its possible to personalize the errormessage so the users can understand it better that access...

Hi. I have made a popupcalendar for choosing of dates. My question is if there are possabillity to make so that the user cant choose an older date than todays? Mattias

Hello. Maybe this has been up here before but cant find anything. What i would like to do is this...: I have 3 columns. 1 Date 2 Name 3 Alternative This is a foodordering db. I would like to put these 3 columns in to one and there have "No duplicates allowed" Why? I dont want them...

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...

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...

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

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...

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

Hi. Found an earlier thread in the same problem. (No good answer still but i will try to ask again.) If i have a report wich i search for things that has been registred in the DB by week. Lets say that one week doesnt have any data registred, then its EMPTY in the report.... not null. Can...

Hi. I need a simple help with sumary in a report. My problem is this..... I have a weekly report that shows products we have sold and products we have bought. When a sum these i get the total of outgoing and incoming in that week i have choosen. But some weeks we dont buy anything, just...