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...

its ok I've fixed it, thanks a lot for your help, my next step will probably be having a form and when you click a button that report is displayed, or a subform with that report appears :)

No worries, done it! thanks!

Attached qryDesign.jpg I double clicked the star your right forgot tht step. (I do normally use CamelCase myself but i was in a group they did it differently to me lol) The attached is what it looks like, 1st when i went to the report it showed nothing, then i closed and opened it showed to...

Oh sorry, I didn't realise :) I Attached what report looks like. And sorry, was being dumb, Record Source was on the all tab. And also correct when you click gives that warning shown in your sites tutorial. Also Attached the picture qrydesign.png that show whats happens after I click to...

I think I understand what you mean, except I make the report that shows their ID and there modules taken. And I assume you create the underlying query to modify the results? Except my query doesnt seem to have a record source in properties :confused: This is exactly what I've done so far...

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!

Gah, damn spelling mistakes :) Ive now done that and date stamped it, thanks for all your help, gave you plus rep :D Liam

Ok, give tht a try now. My row source for combo box is : SELECT tblModuleDelivery.Module_DeliveryID, tblModuleDelivery.ModuleID FROM tblModuleDelivery; Seems right to me.. This is my Query: I'll also attached (in access 2000 format) just incase u wanna look :) Thanks for ur help its...

Re: Insert into table with button Ok this is driving me mad now seeing as i think i have it right but it just doesnt work, the combo box populates with the module code but my text boxes that are meant to show the other information just dnt respond even though they have a control source. Think...

Is there also a way to; once edited/updates the values of pass merit etc, to date stamp the change?

Oh I gotcha :) Yer thats perfect mate actually thanks very much, makes me understand it a lot better with an example thanks a lot!

I'm not sure if that is showing correctly (office 2007 im on) it just has on nav pane Query1 and thats it no form? that how its spose to be? when u run query just asks me to enter parameters :D Cheers!

Well I am building a form yes. How would I do what your saying there? Thanks for the reply btw

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: " &...