Search results

After a good night sleep and a look through some other databases I have on file. I think I have found a solution to my out of date stock. And the good thing is, no input is required from the user. I don't want to completely remove out of date stock. They will need to know what Batch Numbers...

Hi Gemma-the-husky You could be right with how specialized the database is but I will be targeting a specific business model. I have done this before and it worked so well that another 4 companies decided to hire me for there data management. In that case it was Paper and Cash register roll...

It's different here in Ireland. I am being commissioned to create the database. I then give the user the right to use the software but not to distribute or copy it in any way. The up side is, I can give it to who I want for as much as I want. The down side, you can't get the price you would...

Thanks for that information. Strange as it sounds it all add's up in some way. This is by far the most difficult project I have had to build. In a perverse way I'm kinda enjoying it :) If I get this to work as expected then it will be so heavily copy writhed the company won't be able to Fart...

Banana Thanks for the link. Very interesting reading and possibly something I could use in this build. The_Doc_Man an INVENTORY system was on my mind when I first considered the build. Most of the data will be dates so I could probably utilize them better. With relation to the use by dates...

Hi Guus That is my problem, I'm not quite sure how to do it. :) I know what I want but getting it or building it has just knocked me For example, How would I make sure the oldest batch is taken first, when that batch is empty I want it to go to the next batch number and so on. There could...

I am building a database that will tell the company what items to dispatch to the customer first. It’s a food company. So getting products out on time is important. I will try explain it. Say the food company makes a batch of 30 apple tarts. This collection of products has a set batch number...

Thanks Bob That did the trick. Is there a way to set the browser where the link opens. By default it opens in IE and I use Netscape 9 as my default browser. If not then thats not a problem. I'm just happy it works :) Alan

The link is as follows: http://www.newebirl.eu/invoices/invoices.aspx?access_key=kp9u87sr1 Nothing happens if you try to open this link from access. Another link is: http://www.newebirl.eu/invoices/1816.pdf This should open copy of the invoice for clients to print but again, nothing...

Hi Chaps I am having a problem with Access 2007. I have a hyperlink field that should take me to a web page related to the specific record I am in at the time. The problem is, they hyperlink won't work. As I move over the link the pointer changes to a finger as expected but when I click the...

I had considered this but I think this would complicate things unnecessarily. I had considered using an array controlled by a button on a form that would create 3 records out of 1. or 4 records out of 1 What I would like to do is carry out all these calculation then rejoin everything in a...

This is a little complicated so I am not sure t can be done!!! I have a query that lists 40,000 records with some being sent to label printing The query breaks the records down so that any record with a Qty greater then 17 will be sent to a second query for a different label to be attached. I...

Thanks SQL_Hell I have just downloaded this and I can now create and edit my database and tables.

This might sound silly, but how do I create a database in SQL Server Express 2005 I downloaded and installed SQL Server Express 2005 (SQLEXPR_ADV.exe) from the MS website and installed it. On my start menu I have a folder called Microsoft SQL Server 2005 >Configuration Tools...

I’m not sure if this can be done in a query but here goes! I have two tables: Table1 Name Address City Table 2 Address County Hub Post via I then joined both these tables into one query. Query1 Name Address City County Hub Post via When a person enters information in the city field it...

Hi Namliam I think you have cracked it. It’s calculating the information as expected and separating the items nicely. Well done. Can this be used in a report or even exported to Excel in this format. One more thing. The headings on the fields are 1, 2, 3, Is there any way to name them...

I have tried that with no success. I cant get it to show the records or even get the query to work. I have a single box that I want the information to come from. Each record has one field called stage_name I would need 6 of the same field with a filter on each Stage_name=Stage1...

I hope someone can help me. It’s a bit of a strange one. I have a query with information that I want to count. Here are the details. The query is for a reps database. At a given time the rep will change data in a dropdown box with 6 options to indicate what stage of the prospect he is at...

I know its a bit late in the day but I had the same problem after useing the code to hide menubars. I have a link on my master form that will restore my menu bars. When I click this and restore the menus they come back alright. Then when I close access and reopen it to open another Database...

I know its a bit late in the day but I had the same problem after useing the code to hide menubars. I have a link on my master form that will restore my menu bars. When I click this and restore the menus they come back alright. Then when I close access and reopen it to open another Database...