Search results

Hi Guys, I have two large csv files that Excel can't fully open so I merged them together using CMD copy *.csv (the files have identical headers so this should be fine). I opened them in access because what I want to achieve getting the unique values into one table. So I made a query and I...

Hi Guys, Bit rusty on Access haven't done it since uni, and not in 2010. I have a file that is too big to open in Excel so I need to take all the people with duplicate identifiers and place them in a new table. Can someone give me some guidance of how to take duplicates out and put into a new...

Hiya guys, I'm trying to write an IF statement in Excel 2010. What I am doing is: IF [Cell with Date in it] is in the last month then put an 'a' in the current cell IF the same cell is 2 months ago then put a 'b' IF the same cell is 3 months ago then put a 'c' Otherwise put a 'd' At the...

Hi People :) I basically need help with a report for showing every record in my student tables column 'Modules Passed' with a value lower than 2. The Table looks like so: I've tried to no avail :/ Thanks!

Can someone help me with the correct code for inserting a value into a specific row or a column in the Database: So, user clicks button, prompt will say enter a value - enter value - and that value is inserted into the right box within the table. This is what I have so far: Dim MYDB As...

Hey people. I have a Database which contains many tables. One of which is a table that contains information about 5 university modules and their Module ID's, a Pass mark, A merit Mark, and a Distinction mark. What I am trying to create is...: A user form which will allow the user to change...

Hey, Can someone tell me the correct syntax for this line of code: Me![txtBody].Value = "Dear " & strName "This Email is to notify you that you have received grade point " & lstSelectContacts.Column(2, 0) "in " Me!cmbModules.ValueI think im getting the concatenation wrong: or i need to use...

Hiya, i have this code currently that places information from my form into a new email message using an outlook express object: For Each varItem In lst.ItemsSelected 'Check for email address strEMailRecipient = Nz(lst.Column(1, varItem)) Debug.Print "EMail address: " &...

Can someone tell me how on load of a database - my main form could open and maximise (so user doesnt have to click on the form to open) :)

Hey, having a slight problem with my access application, i have one form, but i used to have a couple other forms and now those are deleted. so this is fine but when i start the database i get an error, not one that crashes the program or anything it just says: "the form 'frmEmployees' is...

I didnt really know where to post this. Is there a way to when you open my Access program for it to not open in access, just as a stand alone window so i get a more professional feel to my program? So: bypass access and just show my form stand alone? Any information is appreciated :) thank...

Hey, I've tried writing some code that will, when you click the add to database button, look for the value in a dropdown box, use that as the recordset, then let you enter the information in using input boxes. I'm not sure if it will let me do it but i came up with this code, i dont think it...

Hey people, I'm trying to work out a way to let the user of my program add to the database. But i Have 6 tables that i want them to be able to add to, representing 6 different university modules. I'm not sure of the correct way to go about this, dont really want to have 6 different forms for...

Just wondering if it is possible to change a List Box Row Source Using the OnClick Event of a Combo Box. So for example, I have 4 options in a combo box: And when i click each one in i'd like the Row Source of say 'lstPopulateRecords' to change to a different Query so then it would therefore...

Hey, Hopefully this is an easy question: I have a Combo Box (Combo2) and its linked to a Query which populates it with 4 items from a table called tblModules. What i cant figure out the syntax for is when i select an item in the combo box it will then change a List Boxes Visibility to = True...