Search results

Hi all, I have a prob. I am in the UK and my database is stored in Budapest on a Budapest server, it is just stored in a shared file and its very small and people access it whenever they what. In the location it is stored, one of the users say they can see it says '.mdb' underneath the name...

Hey all, Just a quick question to see if something is possible or not. Basically i have a form which the users record errors which have happened with deliveries of our product and have to select the reason why this happened. What i have been asked to do is when the users are entering the...

Hi all, Theres something which i have wondered for a while. On some of my queries, i have the criteria based on combo boxes, throughout my database. I was just wondering why on some of them if i put '*' it shows the results for all of the options in the combo boxes, but on others it doesn't...

Hi all, I am in the UK and the company i work for moved to Budapest and so did my access database and is now on their server. Today a user in Budapest has come with a problem (see attachment). I really don't understand what has happened here...all the user is doing is clicking on a button...

Hi all, my database is based in Budapest, i am in the UK, whilst i was in the database, i lost connection to the server briefly, then an error message came up saying the database was closed wrond and it needs to be repaired. I have tried this, but it says it can't begin to repair it as i am...

Hi all, For some reason now when people try to enter data in one of the forms in my database, it says that it has been blocked by admin. I have checked who has entered data into this form today and know one has, but it says they are blocking this particular form and as no one can now make...

hi all i have a big prob! i opened up my database this morning and it has been working fine all day, suddenly where it is located a copy of my database has been worked, and the original when opens shows nothing, anyone knows what happened?thanks

Hi all, This morning i opened up my database, it worked fine, ie could add new records on to the forms etc but when i went to look at my tables, queries, forms etc nothing was there and an error message about indexes came up. I had a look through this forum and found a lot of useful...

Hi All, I have a annoying problem. Since yesterday whenever i make changes to anything in my database, it doesn't ask me if i want to save the changes, it just does it automatically. It is annoying, as sometimes i am testing things, say on a query and if it doesn't work, i just go out of it...

Hi all, I posted a previous question about the problem people were having access my database from a new location (Was in the UK, they have moved to Budapest). I could not find the answer to my solution, so i just though i could copy the database on a CD and the users could then install it at...

Hi all, I usually search for the answers to my problems, but as im not sure what the problem is i havnt been able to do so here. Basically i have a pretty simple database, it works fine in the UK. The company i have designed it for are moving to Budapest, i have just had an email this...

Hi, I have a slight problem with the some of the dates on my forms. All of my date fields are set with the input mask: 99/99/00;0;_ and are in the format of 'short date'. Some users have found that once they have entered a date, the date mixes up, for example when 31/03/06 is entered it...

Hi all, I have a wizard made delete record button on my form and up until today it worked fine. Now when clicked an error message comes up saying: cant find the field 'forms' referred to in your expression. I have no field 'form' in any of the tables or queries relating to this form, in any...

Hi all, when the users are saving the form, i want to make sure they have filled in certain fields. On previous forms my code has worked, but for some reason on this form it won't, i usually put: If tankID = "" Then MsgBox ("Please Enter the Tank ID") tankID.SetFocus End If Can anyone...

Hi all, This is just a quick question, for one of my fields the users enter a number, this could me a minus or positive number. I have been asked to produce a report which shows the total of the minus number and the total of the positives. I have set up a query for the minus number and have...

Hi all, Im just wondering about a date stamp which is in one of my queries. The database which i am working on is for a fuels company, one of the tables they have is a runout table, obviously for when fuel runs out at a station and also contains sales history. They have used a date stamp, so...

Hi all, I just have a little question which i can hope someone can help me with. I have a form where the user selcts from a combo box a shop name, i have then a text box which the user types in a number. This number is to show all of the shops which have had a profit greater than the value...

Hi, I have a small problem with a cross tab query. The query works perfectly when i run it and displays the data in the way i would like it to, i want it to be on a form though and when i try and do this i get problems. I get either a message saying i have possibly chosen a query with no...

Hi all, at the moment all of my field are control sourced. I heard there is a way whereby the field could be unbound and one button it the control source for them all. Im not entirely sure what this means or how to go about it. But i think it would solve the problem of if my users start...

hi, i have a form which shows all of the transaction that have happened in the business, a field in the form is 'logged by'. The 'logged by' field records the name of the person who completed the transaction. For monitoring the employees performance i have created a query which shows all of the...