Search results

also the target is different for every store, in the input for there are navigation buttons that direct the user to the correct store. i have tried IIF statements and vba code.

thank you very much that sort of helps, the mix and match looks like it could work. i just want to make it clear that this is for my A2 ict project, and therefor i am not to familiar with access Just so i am clear my database allows my client to enter end of day sales figures in to a sub...

I am making a dp for end of day sales, and i want to compare data in a table to the numbers inputted in a form and see whether this value is higher or lower. the table displays the target sales figures for each day, and the form allows the area mangers to enter in the current day figures...

yes that's stupidly simple, so just run DELETE FROM table_name; or DELETE * FROM table_name;

yer if you just go to C:\Users\Username\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup and place the file in there as shortcut it will open upon start up

Hello there i was wondering if anyone could help me with a project of mine for my a2 ICT course, my database just records end of day sales figures which are entered though a form, after they are entered the total for the day is archived. However the problem i have is that the i need some way of...

so steve how does your school do the subs button and the archive button? And thank's you every one for all the help

so steve how does your school do the subs button and the archive button?

well thank you for the quick responses guys, i made the little changes to both Dim db = CurrentDb() and [Membership Number] or [MembershipNumber] thanks David and Paul so how would i change the vba to a form parameter for both the archive button and subs button.

(i will state first, i am a novice when it VBA so if the answer is simple i apologize now) as part of my as ict alevel we have to make a database and in that a form, within the form we are tasked with a producing a button. this button's function is to add a new yearly sub to the table. however...