Search results

Thankyou. Sleep well! :) ~Markus

Thankyou for your response pbaldy, Now I'm possibly starting to sound rather slow but I can't seem to get my head around this. So if I'm correct. I have a main form named fmCustomers, and the subform, sfmCustomerOrders is 'property' of fmCustomers in the way of another control, with a...

Hello, I'm still new to access in general so please excuse my lack of knowledge. I don't think I have tried the above, from what I understand do you mean switching the code from the "on load" event to another event, with respects to my Order form? Now indirectly I have managed to get it to...

Thankyou pbaldy, Using the information supplied by yourself, I tried to replicate something very similar to a previous query you helped me with, which was Linking a button on a form to a report but to only show the data I was currently viewing, so effectively the same as this! However Im...

Hello all, Okay so I have two tables, tblCustomers and tblOrders. I have appropriate forms for both. On one of my forms being fmCustomers I have a subform which is called sfmCustomersOrders, which simply gives an overview of all orders designated to that customer. Currently I have to...

Hello all. Okay so Ive been creating a database with help from many of the friendly folk on these forums and whilst my database has a real-life use so to speak, and hopefully will be used once complete it is just a basic project that I'm learning from. So basically my database is used to...

Haha I thought it was a little different :), Im going to re-use this thread, possibly should make a new one lets see how this goes. Okay well I have added a close action to all my buttons that link to another form, so ideally only one form is open at any one time. My problem comes from a...

Thankyou once again Beetle! This worked as intended however out of interest how would I do a similar thing but based on a query not a table? --- Whilst writing this I thought I'd try putting the query name in place of the table name and I believe it worked! Success! --- ~Markus

Thankyou for your assistance Beetle, This worked perfectly, It seems so simple now. ~Markus

Hello all, What I want to happen is the following but I'm unsure of how to go about it! So, on my main form which is my Main Menu with buttons linking to other forms I want to add several boxes that contain the total number of records, for example: Customers: <Total customers here>...

Hello all. I'm using MS Access 2007, I'm hoping somebody could shine some light on my problem. Basically I have a form that allows order entry into the tblOrders, My database is based on the opthalmic industry, therefore I have effectively two data sets for each order, one for the Right...

Thankyou pbaldy, Unfortunately I have not had chance to check back here until now, I havn't tried your approach to my problem as I managed to solve it by using the Macro builder I believe, to your question though Order Number is a numeric field yes. For anybody interested what I did was the...

Thankyou once more Missinglinq! It appears to working as intended, but I'm once again having a slight problem which I think is down to my design. The problem is if I open up my "main" form which has buttons linking it to the orders form and customers form, then go through to customers form...

Thankyou for your reply missinglinq, With a bit of patience your code did the job aside from one problem that I am now facing.. Perhaps a design floor on my behalf. It won't allow me to "copy" the ID so to speak into the order form. The error message I receive is "You can't assign a value to...

Thankyou for the link pbaldy, I have tried to put this to use by doing the following: I have created a new "blank" button so to speak, on the event 'On Click' I have added a event procedure with the following code; ------ Private Sub Command122_Click() DoCmd.OpenReport "[Order Print...

Possibly a misleading title, I'm not sure but please help if you can :)! Okay so I have two tables both with appropriate forms: Customers and Orders, both are linked by a unique field being CustomerID. I have added a button that allows me to go to Orders form, from the Customers form...

Hello there, I'd like to start by saying I'm very new at this, Its a self project (sort of) and I aim to start small and develop it as I learn. In a nutshell I'm creating a basic database that consists of a Main Menu linked to two forms (Customers and Orders) these are linked by a unique...