Search results

Firstly thanks to all the hard working people on here helping others. This forum has been the source for problem solving quite a few times. This is driving me up the wall now and it's probably wood form the trees but here goes. I have a folder under the default on in outlook named ANOTHER...

I wondered if users here have a certain workflow when it comes to deploying and updating adp projects. I am considering making a project using access 2010 and sql express r2 2008. I am used to using access with jet projects on a split front end / backend format. I am not however familiar with...

I have returned to this good ole faithful forum in the hope that somone could assist in my technical stumbling block. It has been years since my last visit but upon returning I still see the pro names with massive reply counts. My hat's off to those who are doing this as a profession and still...

Please could someone enlighten me on the following scenario I have. I would like to get from a button click the information from Sheet_subID (cat_parameter) copied into the Main sheet Description field. I think this maybe would be done with a loop? Taking one from in tunr from Sheet_subID and...

What criteria would I need to apply in order to show the last 100 entries in a record set? Lets say I have a table NoteID - Autonumber Notes - Memo How would I go about displaying the last 100 NoteID's I'm sure there's a dmax or d something but I could not find it within the forums. Regards...

This is a very simple one people but my brain has been fried over the las few hours. Please excuse the messy layout its just for working. See below Basically when moving into form one how would I move te record in form two to the current Orderdetails_counter? At the moment the record pointer...

Just wondered if viewers had any suggestions for this one? I'm tidying up my works booking in system and instead of a person having to manually open the sub / sub forms then I wondered if I could have a button on the top form for instance "ORDER COMPLETE" Then upon clicking this button table C...

input mask from combo Although I have not yet looked deeply into this scenario I'm asking to see if anyone had approached this before. What I need to do is change a text box input mask dependant on a user choosing a combo box. The reason being I would like to record delivery note numbers in...

Counting same IDS Here is a question for all you query experts, Just say I have two tables Job number ID (Pri Key) Job Description etc Customer ID (Pri Key) (IS a sub of job number continues form) Name etc How would I count how many instances of customer id's occur under the specific job...

I'm working on a rough sketching out of a timesheets DB and have the following problem. It seems that I'm getting wacky result from the datediff function. I have the following structure Main timesheet table Sub timesheet Time In table Time Out table I would just like fot the datediff to...

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...

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...

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...

sub form visibility defined by check box validation Here's a doozy for everybody.... I have a sub form which is part of a purchase order. This sub form is also used in part of my >>booking in form. The reason being employees would view the contents of an order to fill in the quantity delivered...

I wondered if anyone had an idea for this problem. We currently use a purchase order system designed by my good self my only draw back at the moment although not essential it would really put the icing on the cake. Basically when a user chooses which items they wish to order they are created in...

I have had a look around and couldn't really see a solid solution to this problem. Basically I would have this scenario A user would make a purchase order and fax it to a supplier this being done through winfax. What I would like to do is when the purchase order is printed send the PO to both...

Just wondered if it is possible to have a form button edit the url of a hyperlink? I say this because I the right mouse button disabled but would still like a user to edit / update the location of a hyperlink. Regards Ade

Just wondered if anyone has noticed that when sending a report directly to WINFAX it does not appear to show any check boxes? Or is there a setting that I have not taken into consideration? This could lead to considerable problems should a questionnaire be required to be faxed to someone. BTW...

Here's a question that may require some VB. I'm currently reading ACCESS 2002 VBA (ISBN 1-86100-821-X) and its a steep learning curve at the moment. My situation is this, within the DB many manufacturing projects are currently created and a delivery date specified. Basically is there a way of...

I'm trying to create this Dcount procedure to maximize access from the task bar should a new note become present in the job history table. It looks to me that if the ID value has increased then this should in theory bring up the page. The timer event is set to thirty seconds. With this code...