Search results

I am putting together a supplier and product database and have a slight problem. We have a large number different delivery locations and each of our suppliers deliver to a different combination of locations. I want to record where each supplier delivers. I have an idea of how how this could...

I currently have a database that is missing various pieces of information, we are getting a temp in to complete this. I don't want the temp adding data directly into Access so I have exported the table that needs updating into Excel. How can I then import the new data without altering current...

Not sure if this is possible. So any help would be welcomed. What I want to do is have a small form sitting in the corner of my window that you can see all the time regardless of what I am doing in other windows (like the function in Winzip, to keep it on top). So I can just click on it...

I have a report that that when run, a 'Enter Parameter Value' box pops up for Total. I am 100% sure there is no tags in the report, i.e [Total] which would genrate this as I have been through it meticulously. When I run the query the report uses separetely it gives me the data I need without...

For some unknown reason I am unable to open the back end of my database, as far as I can see it has not effected people adding data through the front end, I just can't open the back end. I checked the file format and it has changed to a LDB file, no idea what this is or why it has changed, any...

I have a form where a user reviews information input by another user, once they have done this they sign it off by selecting their name from a drop down list. On this form there is a scrolling message which tells the user how many un-signed entries there are. This works fine until there are 0...

I have recently split my database and added a password to the back end. I am now trying to re-link the tables as I have seen in other threads, but when I do this I am not prompted for the password I just get the message 'Not a valid password' I must obviously be doing something wrong, can...

I have a standard Select query with various fields, three of which are: - Quantity Ordered (number) - Quantity Delivered (number) - Short Delivery (checkbox) Basically I want the check box to be checked if the qty ordered value is greater than the qty delivered. I have this code in the...

I have a query linked to some combo/txt boxes on a form so the user defines which categories he/she is looking for then presses button and query comes up with relevant results. This works fine if the user inputs information that is actually there, but if they leave it blank it goes all wrong...

Thought I best ask this question BEFORE I run into trouble. If I were to set my database to hide the database window and all menus on startup so that users can only do what I want them to do and not edit anything. How do I go about reversing this if I needed to edit something as I would not be...

I bet this is a simple one. I have a form with the on Load command Docmd.Maximize On this form I have a button to open another form, this works fine. On the second form I have a button to close the form. When I press this it closes, and the first form is still there which is what I want...

Hi Have scoured the forum and have found people with a similar problem, but I just can't seem to get my head round this. Basically I have a table with various fields, one of these fields is a sign off field where the user enters their name once the record has been reviewed. I want to count all...

I have got the following code off another thread which works great! I was just wondering if there was any way I can link the scrolling messages to a table so rather than having to go into the code to alter the messages the user can change them through a form or in the table. Option Compare...

I am trying to create a scolling message and found this code on a previous thread but when I run it I get the error '7952 You made an illegal function call.' When I click OK it just comes back again, and again and again. The only way to exit is restarting my computer. ANY HELP WOULD BE MUCH...

I bet there is a simple explanation for this. I have a form which opens automatically when the database is opened, but I want it to open in the maximised view so it takes up the whole screen.

I found another thread which answered my question about creating a log in: See Thread Only problem is I can't seem to get it to work can you please take a look at this line of code and see if you can spot an error, I think this is where it is occuring If Me.txtpassword.Value =...

I have recently been working on the code below and I have neally completed what I want to do. Private Sub H_Enter() Form!H = "hyperlink#E:\WORK\SPEC PROJECT\WORK\SPECS\" & Form!S & Form!PC & Form!extension & "#" End Sub What I want to do is have the file location (bit I have bolded) stored in...

Hi Everyone I have just solved one problem concerning creating hyperlinks based on values in other fields: See Previous Thread but now I have another, the hyperlink I have created links to a document, while for the majority of time it is a word document it is not always, occasionally .xls or...

I am trying to create a hyperlink from other values in a number of fields, I have found a thread which I think anwers my problem: Link to Thread Only problem I is I don't really understand it. :confused: e.g. Dim stGunlib As String Dim stGunlib2 As String stGunlib2 = Me![Stock number]...

My problem is as follows: User group 1 enters information into a table via a form. This information then needs to be signed off by user group 2. I have created a query which shows the information in fields 1 to 10 which I want to be protected so they can only view this and not edit it and...