Search results

Heres the chopped DB Just the bare essentials but I would like the details from the Invoice section to copy themselves into following record set with the use of a button. I will explain more should you need it. Cheers Ade

Ok I will see what I can do tonight. It will be the absolutely bare essentials though as this is a very cut down version of my DB that I made for work. I'm basically lashing together another small database for my wife's business. Its very much in the development stages so this would be a...

Holy Contraceptives Batman You have just blown me away, I think my brain was fried on line 5; is there an example db you can post in order for me to pick at?. From your response you are a pro. In answer to the primary key yes I would like a new one generated when then information is copied...

Right I know I have only just put up a post but I'm refining a DB and wish to gleam some knowledge in order to put those nice little touches to it. I have the following form, some fields have been ommited for clarity. Form Main QuoteID Date of Creation Sub Form (Continuous) QuoteID Quantity...

Like charm Works like a charm. I'm just about to post another on the forms list so please have a look. cheers Ade

I would like to get over this... I would prefer to disconnect as my backup software cannot access the file when it is open. I don't wish to introduce anymore code to export data either, cheers for the suggestion though ;) . Any ideas for the above question?

I wondered if anyone would know of a simple way to acheive this scenario. I have a text box with the =Time() function refreshing using the timer event. This just shows a clock. At ten oclock everybodies front ends automatically disconnect from the back end allowing backup to an off site...

Quitting Try DoCmd.Quit I have had several problems with user not disconnecting from be and app still running. The is a little hardcore but it works for me. Cheers Ade

time to shut down Another question for the experts I would like to display a text box telling the user how long they have until the DB shuts down say 9.30pm, hours min secs. Any ideas?

Cheers mate that is a solution.. great Cheers mate that is a solution.. great

Just wondered if anyone knows of way of closing the a DB at a specified system time? This would be very handy for me if every user has unlinked themselves from the back end (situated on a shared network drive) as I believe that should a user still be logged in and backup try to commence it...

yeh I just sussed that about 25 seconds having written the message. With a report its completely different to on the fly input forms. Cheers Everybody for their effort.... Onwards and upwards Ade

sequencial numbering Would it make a difference if I said I would like to do this in a report this way whatever the report gets is final i.e. the user cannot delete lines what you see is what you get. Is there some way in code I could assign an initial value to a text box and then for every...

Like a charm Brill! One more step down the line to a solid booking in system. Cheers Mate :D Ade

Finding nulls and replacing them with zero's I know you have helped out a lot neileg but what how would you go about this I have the following table structure. Order Details OrderID From PO Table Product Required Delivered How would you go about finding the null values in the delivered...

Yeh I did that but previously unformatted records in the table do not get zero as these are assigned only when a new OrderID is created. This is why I needed the append mehtod I have got as far as using the nz command to put zero in all delivered table entries that have a null value but when I...

The penny has dropped neileg.... I have gone the query route and the bookee having filled in the delivered quantity activates the query with a refresh. This then only shows the items that have not yet arrived. >>My final question is an append query related one. Basically I would like to...

So many questions but happy to answer...... The "quantity to come" is arrived at by just taking the required by the delivered with a simple control source equation. The top half of the form records who, when and what is to come on the order in a separate table. The bottom part of the screen...

Booking In These items are being booked in on an individual job basis. The original PO sub page table contains order id, Product ID,required, delivered The delivered field is not shown in the purchase order but only in the booking in form. This PO sub form is used on the booking in sub...

Booking In Sorry but my explanation must have been vague. I'm using the purchase order sub form in a sub of my booking in page. I would imagine a person booking in items would click on the click box say "these parts are in" and they would become invisible (only when viewing on the booking in...