Search results

Do you have any good links for reference with this, its not something that I have done before and am struggling to pull it off it seems

Hi, I am currently putting together an "administration tool" for an access form I have built and I am looking to have it so users would log in to the admin tool and have options (command buttons) visible based on a 1 & 0 system. I have used to following to create the login form but I wanted...

Yes that is correct

The main form uses the same query for it's record source and then each of my subforms are built basically to show combo boxes listing specific columns from the query/table. For example the table is "callouts" This has an application name, the service, the support team and a like to web...

I'm looking for a search function that will allow someone to search from a main form which contains 3 subforms that all are of combo boxes with different parts of information from a query. For Example: Main_FORM Service_SUBFORM Callout_SUBFORM Contacts_SUBFORM I want to have a...

Brilliant! It worked, thank you very much

Still getting the same error when doing that, no current record - driving me crazy I can't understand why it can't see it. The naming may throw you off a bit, it is infact a list box, it was originally a combo box and I never renamed, so the list box uses a query to list all the applications...

it doesnt seem to like that. Once it gets to .Edit it fails. Private Sub Combo2_AfterUpdate() If Len(Me.Combo2 & vbNullString) <> 0 Then Application.FollowHyperlink Me.Combo2 End If Dim db As DAO.Database Dim rs As DAO.Recordset Set db = Access.CurrentDb Set rs = db.OpenRecordset("SELECT...

Ok, maybe I'm not as sure about the query as I was - I have a query that sorts the applications into alphabetic order, I assume I would add my "ClickCount" column into this query and then make it increment the number? The applications list from a search query, would I need to add an update...

I have an access form which has a list box of applications which people click to quickly launch, I want to be able to track the number of times each of these is clicked to create a top 10 frequently used applications - is there a way that if I create a column for clickcount in my applications...

I have a form "Handover" on this form I have a button that enables edit functionality once clicked, I now have a subform on this form named "Bdown". The Bdown subform allows edits without having to click the "btn_Edit" on the main form "Handover". Is is possible to make the edit button on...

Hi, I have a form where I need a button that will export the current record being viewed to a TXT file and attach to email, I want to specify the To, CC, Subject and Body of the email, if possible putting a flag on it also. I'm not doing very well, so far I have Private Sub...

I have posted the code above.

This is the code I tried; This is not pulling the single record either.

I have yeah, but when I try introduct my WHERE function to look at the dates it seems to dislike it.

I need a script to run a report "executive incidents" pulling data for only the current record you are viewing. This needs to be emailed as a RTF with one person in the TO field, one in the CC field and a small body of text. Ideally I would like the RTF to output in landscape if possible...

I have a single table, the two fields used would be: 'Peopleonshifttonight' - this is where I want the selected team to go and 'Team' - this is where team 1-4 is selected, I want this selection to input team members names into 'Peopleonshifttonight'

I have a form with a list box on it that has 4 teams (Team1-4) Below this list box I have a text box: "People on shift tonight" I want to be able to select a team from the listbox and this prepopulate the people on shift box with the names of the colleagues from the team specified, is...

When you are refering to MemID, what is that. For example you've said WHERE ID=MEmID?

This is what I've tried so far using CJ's code. I have also tried: