Search results

Hey all, Probably an easy question for the more advanced people on here! I have a subform that I would like to filter based on a combo box stored on the main form, just above the subform. I've googled this but most answers seem to suggest using VBA. Not being that familiar with VBA I was...

Thanks for your reply however, I think I've not made myself clear. The continous form is actually on the second form. I am just a little confisued as to how to make this continous form "see" that i've passed the ref from the main form? Thanks, -NS

That's great! Do you know how I would use this with a continous form? I basically need to be able to update my records everytime a new paper is submitted. Many thanks, -NS

Hey all, I am looking at ways to open a second form from an employee main form. I need the second form to display certain data based on the record that is displayed in the first form when the button is clicked. Example: If I navigate to customer ref 212 and then click a button to open a...

Thanks for your quick reply David! I was planning on having a "comments" field where the user could enter what was changed and why. Is there a simple way to clone the data or would it be a manual copy and paste job? Thanks, -NS

Copying the row above for editing (to track changes)? Hey all, At the minute I have an employee database made up of 5 tables. I have a query that pulls certain data from each table and displays it in a nice neat table. Here is the tricky bit...Now I need to keep records of all previous...

Hey all, I have an interview coming up and suspect that one of the questions will be relating to managing conflicting deadlines. (i.e. You have 2 pieces of work that are due at the same time and are of equal importance). Just wondering how you guys and gals would answer this? Thanks -NS

Many thanks, i will try this tomorrow.

Just checked and it's the same as your screenshot.

Very strange, I right clicked as suggested and I could see the menu but it was greyed out, I cant select anything. -NS

Thanks for your reply vbaInet! I'm not sure I'm looking in the right place but there are no ribbons/tabs in Access Runtime? Thanks, -NS

Hi all, As per title really. I have a database that takes a while to open on some peoples computers. I had the idea of opening it in Access Runtime to see if it speeds things up. I just tried and it is a lot quicker however, rightclick is disabled. The key things I require are... 1) Being...

Hey all, I have a set of simple stats at work which is made up of 3 columns. The first column shows how many people COULD complete a task. The second column shows how many people HAVE completed the task. The third column is a % of 'Have' against 'Could'. Now, this is where it gets tricky. In...

Hey all, Apologies if 'Matrix' is not the correct word to use but here it goes... I'm looking at the idea of creating a sort of matrix spreadsheet type look but in Access. I need to have names down the left most column and multiple dates across the top. I could then enter a Y or N to show if...

Thanks for the quick reply Banana! That looks like it could help! By reading that article, it appears that access will keep the conenctions open. Would this cause a problem with record locks? I'm unsure if the locks are based on the record or the table. If it's the table then I guess it would...

Hey all, I currenty run a database with a FE/BE design. Each person has their own FE (not a shortcut) which connects to a back end on a shared network drive. This si done via Link Tables. I'm having problems with the loading time or rather the loading process. It will often freeze (white...

Thanks for your quick reply. Just a thought, but could I set the focus to the new "input" fields? Thanks, -NS

Hey all, Is there any way I can make a subform put a new blank record at the top rather than the bottom? Problem is, we are getting a lot of records now and scrolling to the bottom in input a new record is getting annoying! Also, I have a menu that always stays on top of any other Access...

Thanks for the help dude :)

Thanks! The only issue that might crop up is that i'll be getting the data from an external source database via ODBC links. Will this cause a problem?