Search results

Mile-o-Phile Tried your sql, seem to get the param box again. SELECT DISTINCT tblTrainingRecordSubForm.Item, tblTrainingRecordSubForm.Category FROM tblTrainingRecordSubForm WHERE...

Hi, I can't seem to get a combo box to filter another combo box via a query in the row source on a subform. I have two combos: SelectCategory and SelectItems In the row source for the SelectItems i have the following query: SELECT DISTINCT tblTrainingRecordSubForm.Item...

Problem: I am setting up an output email by using 5 reports from our system. The code runs through each report, attaches it to an email and sends it out to the recipients, this works well until the report has no data. The code just seems to stop and the reports after it fail to load and send...

Is it possible to run a db by using the standard task schedular if the db has security on it? The reason why i ask is i have tried to do this and the task stops, methinks it is because of the logon prompt is waiting for a password. I am using a batch file to open the db, is it possible to add...

Would this not limit the PK to " PRO9999 " numbers? or would it allow "PRO10000" Just curious as i am setting up a similar process. Matt

Firstly: I'd say loose the free counter, you don't need it. It gives the site a "Homemade" look, even on the new design! They also slow page loading down. I would check with your ISP to see if they have stats available for your site, if they don't suggest move to a better ISP that does give...

Thanks for pointing me in a direction. I have been scouring the web for examples, schemas but didnt find alot. It almost seems to be a taboo subject. What i did find was lots of software houses which could design BOM databases at a very high prices but no actual breakdown on the correct way of...

I really need some input for a design of a BOM style (Bill of Materials) database. This is my second post to see if anyone can help me or point me in the right direction. The project: (this first part is not a problem) What i need to do is create a database where users can input an assembly...

Ah got it! Create a text box next door to the number box. Enter the following in the Control Source ="#" & [NumberBox] & "." (Dont set it to running sum) "NumberBox" being the name of your accumalitive box. Make the accumalitive box (NumberBox) invisible and voila!! hope this helps Matt

Not sure how to get it to do that the "proper" way but if you create a text box right next to the number box and enter the following in the control source: ="#" This will produce the hash on every line produced, as for the period after i'm not to sure. There may be a way of doing this but...

Ah yes the number a line problem in a report, no it well, heres the solution: Create a blank text box in the details section of your report next to the line that you want to number. Right click and select properties. Enter the following in the control Source: =+1 In the running Sum property...

re: Hi, This may help you, Right click on the text box to bring the properties up. Check out the "Decimal Places" property. If on "Auto" select to "2" or "3" decimal places.

I need some "Pointing in the right direction" on a new project that i need to get up and running asap. I need to design a database that allows users to set up a bill of materials with the following fields in a main form: Assembly Number Batch Number Batch Qty And in a subform: Part Number...

Hi, I can sort of see where your coming from though trying to code it may be harder to do. I think the loop would do the job as i could get the loop to look at the Qty field and loop through X amount of times and produce X amount of pages though i'm not sure how to send that data to the report...

re: Hi Liam, The reason why you are getting a blank piece of paper after every print is that you have set your report area larger than your paper size. I am guessing here but lets say that you are using A4 paper size the area of your report is larger than A4 hence the extra piece of paper...

reply Look at the following in MS Access help system: reports,Page Numbers,Reset page numbers for each group in a report. I am sure this will help you out if your report is split into groups or if not split it and go through this help file. regards Matt

Just designred a c of c database which allows the shopfloor test guys to create an outgoing c of c. The database holds the following fields: C of C Number Date of Issue Customer Part no and iss Batch No Qty Despatch/Invoice No Description of items Details of tests Concessions Authorised for...

I think i can answer your first question: In the reports design view go to page setup and select either landscape or portrait. Ok that and click save. This will set the page orientation to whatever you selected as a default to the report. Works for me. Your second question i would imagine...

I have a project where a piece of equipment needs to be plugged into a serial port and the data downloaded into an Access 97 db. Has anyone actually had any experience in doing this, if so would they like to share the VBA code that they used? I have been searching around the web trying to find...

Alexandre, thats it, it works!!! Thanks for everyones inputs with this. Just one small thing, is it possible to place the wildcard * at the start as well so that any permatation of numbers will be found? Thanks again everyone. Matt