Search results

ok i will explain this as best I can but please remember I am a very very nooby access bloke. I have one table I have one form I have several fields in the table of which three of these are AM Takings, PM Takings and then total takings. I want to achieve something that is (or so i thought)...

Sorry my question wasn't clear. I have a 3 fields AM Takings - So in here we enter total AM takings (£100.00) PM Takings - So in here we enter total PM takings (£100.00) Total Takings - This field will sum the AM and PM takings (£200.00) Thanks Anthony

Ok guys I have a quick question. The Background I have created a very simple database so that I can enter takings from the shop on a daily basis. i have put income and expenditure into the same table then created seperate forms for data entry. The questions I am looking for a way of auto...

Sorry, a rota is a working or shift pattern sometimes called a rosta . . I assumed it was possible to set 7 fields titled Monday through Sunday, put yes or no in the fields against staff name and then where yes equals true then add name into report for working that shift. Thanks Anthony

Hi guys What I am looking to acheive is an auto populating rota system. By this I mean that Mr X works monday day tuesday night and wednesday day whilst Mrs X works monday night, tuesday day and wednesday night. Is there a way of setting the work patterns in the table and then populate a rota...

Update, this is the code for the yes button to opena new record . Private Sub New_Record_Click() On Error GoTo Err_Exit_Click 'Confirm close If MsgBox("Has a ticket been raised for the incident you are logging?", vbYesNo + vbExclamation + vbDefaultButton2) = vbYes Then...

Ok a little bit more help and i'm done (i think) lol Is there a way of coding the yes no box to display a msg when the no button is clicked rather than just returning to the menu ? Thanks Anthony

PBaldy Thank you for all of your help with the trusted location stuff, all working fine. Thanks Anthony

Indeed thank you, another question for you that is defo beyond my access skills (i think lol) is there a way to password protect the tables so that everybody has to use the front end forms? Plus is there then a way of having a button that will open the table after a password verification...

Err my signature might have given you a clue , Access noob, so to your question . . . and my subsequent answer . . . . pardon. Anthony (Access Noob)

no ther code in DB running everything on macros. Trusted location, yes on secure server at work!

Here is the code Exit Application Code Private Sub Exit_Click() On Error GoTo Err_Exit_Click 'Confirm close If MsgBox("This will close Microsoft Access, Are you sure you want to quit?", vbYesNo + vbExclamation + vbDefaultButton2) = vbYes Then DoCmd.Quit Exit_Exit_Click...

Hi Guys I am using Access 2007 (Works choice not mine) and I am trying to get a message box to pop up when a command button is pressed, simple enough but i want to have a yes no button on the box to either continue with form opening or to bounce back to the main form. I have written the vb...

Hi guys i am looking for a piece of code if anybody can help. I have a text box that is hidden due to it mirroring another box that is running an equation. I assumed that a simple Me! function would work but alas . . no. So what i need is code to allow me to save the value of my text box into...

Hi guys Couple of questions. This is the first time i have created a database using access and am having an issue. I know from the one part what to do but its excaping me the process to follow. 1/ Need to bind a text box to a table, now obviously i just enter the value into the control source...

full page forms Okay have sorted the combo issue by putting code behind the button and using the .field functions. Does anybody know the sizes to have a full screen form showing not opening as half page ? Thanks

details Imagine having a combo box that you can select a name from. Once you have selected the name you can click on a search button and for the required fields it brings the data onto the form. No Saving or editing just to view the required information solely from the name in the combo box

explanation ! Effectively what i want to do is have a from with blank boxes on for each field so name address telephone email etc then once a name has been selected from the combo box and perhaps a search button would be added it will find the required data and fill the empty boxes with the...

last post misleading - sorry I just re-read this and realised it might sound confusing. The form is designed and set out with text boxes, once the name has been selected within the combo box i want the form to populate the text boxes with the recalled data.

Thanks - let me expand I am looking for the combo box to hold a list of client names, so obviously i link the combo to lookup the client name field fine no probs there, but once that name has been selected i then want the form to auto populate and recall all data from both tables with a...