Search results

Brilliant, that's got it, thanks! The point is that this will be quite a rarity as staff join at different times and there's only a handful of people in this department, 12 at the most, and all their training will be at different times. It's more to trigger the user to send an email and set up...

Similar, it's to show when a staff member last had training (I'll change the date entry part to less than 2 months ago), and if that training was more than 2 months ago, show a message box. Eventually, this will go in an invisible subform on the navigation page so you see who needs training when...

Right I've changed it to a Single Form, moved the code to the Current event and changed the line to read just .MoveNext but I'm still getting the same problem, it just shows the name in the first record 3 times?

Hi All, In my database, I have a continuous form with a Name, a Date and a Yes/No field. When the form opens, I want to look at the date of every record on the form and show a message box if it is before the current day. The code I have is this; Private Sub Form_Load() With...

Hi All, I'd like to be able to drag and drop a file from an email onto a record on Access. I believe the best way to achieve this would be to create the hyperlink to the temporary file, copy the hyperlink and then use the FileCopy method, however I'm having some trouble creating the...

Quick bump, anyone got any ideas? I read up a little more and the where condition currently looks like this: "[fieldname]=" & [Forms]![JobCard]![controlname]" The fieldname is ID and the controlname is ID1, both are number fields (it's the PK and is an autonumber). When I run the macro...

Neither form is Data Entry, each ID is unique but both forms look at the same set of records, so obviously the ID from Outstanding matches an ID of a record in the Job Card form. I'm using the OpenForm command in the macro builder, it's the only option it gives me.

Hi All, I'm creating a couple of web forms and I want to open another form to show more information about the current record. I have a continuous form with all the currently outstanding work, and when I click on a certain field I want to be able to open the Job Card form to that specific...

That's got it, thank you!

Last record meaning the newest one, the record with the highest Primary Key number. I've changed my SQL Statement to this; DoCmd.RunSQL "UPDATE [MASTER PLANNER] SET [MASTER PLANNER].[USER] = Forms!frmLogin!cboUser.Column(0) WHERE [MASTER PLANNER].ID = (SELECT MAX([ID]) FROM [MASTER...

Hi All, I have a button that runs a line of UPDATE SQL, but I want it to update the last record. How would I go about this? I assume it's part of the where condition but I'm not sure how I'd achieve it. The code I have so far is this; DoCmd.RunSQL "UPDATE [MASTER PLANNER] SET [MASTER...

I already have that, but what I mean is, is there anyway I can create a table with the users in and what forms they can view and get the front end to look at that and then determine whether to allow the user in, rather than putting code on the button itself?

Hi All, In my database, I have a login form which users enter their credentials into and then can access certain forms based on their department and access level. The problem I have is that the credentials are coded into the front end using VBA on the OnClick event of the buttons to open the...

Brilliant, that's got it! Thank you so much!

So at the top of this module I'd put Public whatever As String and then in each form I have to replace with "txtClicked" with "whatever"? The Public flag is declared at the top of each form too so would I have to delete that or also change that to "whatever"?

See I tried something like that, in the top of every form's code I have this; Public txtClicked As String This is set to "No" when the form is dirty and when the save button is hit, it's set to "Yes" to allow the save function to continue. In the module, I tried using the same flag and...

Hi all, In my database I have module that checks if tick box is True and then closes all the forms and kicks the user out of the database. However in most of my forms, there is a custom Save command in the On Click of cmdSave button and the Form_BeforeUpdate. The save requires certain things...

Well the other problem is that ImageCapLeft should add up to 100 and it's not which I don't understand either. EDIT; never mind, I figured it out. I didn't see the second axis on the right next to the legend (derp), so I changed that and now it's coming out like I expected.

All the data is definitely there. I double checked that the chart was set as stacked for the secondary axis and that partly helped but for some reason it's still not quite what I'm expecting. The chart is in rptCapChart, and it's based on qryCapacity.

Sorry, I didn't get a chance to carry on with it yesterday. I've nearly got it, the sample data it shows you in the design view confused me at first. I still have one problem, I've changed it to a 100% Stacked Chart and for some reason it seems to be missing off one of my data series?