Search results

you know what could help lots? Please post the names and structures of your tables. I think if the foreign key is already there you might not need an append query at all.

This is proving a really good read, and I also like the style beside the contents, thanks for sharing! On a side note: we also use "università" (closer to English), and it is also probably more common than ateneo. Ateneo, though, has a more ancient ring to it, as it is derived from Athena, the...

Thanks for the resource. tblUniversity is how I would have called tblAtenei if I had given it an English name :) I'll get back to you (or not, if that doc enlightens me sufficiently) once I'm done reading.

this is happening because the IsNull condition will always be false as long as even only one record is not null. I think you would have to open a recordset via VBA and test the condition on all records, if you are going to have more than one to check. If you are not familiar with recordsets, I...

ID_Ateneo is pk for each university's record on tblAtenei. I'm not using pkeys on the other table, I only bothered using ID_Ateneo as a fk to link the data (as all entries an all different table will be related to a given university). Am I supposed to use an autonumber anyway (I don't really...

Please let me point out that you're hardly going to receive a reply if you ask like this. I have no idea what SPSS is, anyway.

I am under the impression you are not using forms to visualize your data, is that correct? Opening the tables directly to edit the data is something any decent designer will always recommend against. If on the other hand I am mistaken, you can simply use a conditional query for your datasheet...

Hello and welcome to the forums. This sounds like something you could easily handle with a query. First off: have you imported on an Access table the data from the Excel file? There is an easy default feature to do that, in my version (2010) it is under the section "External Data" (or...

Dear all, I seem to be unable to get this right, and it always takes a lot of time to plan in advance, so rather than screwing it up and then hastily patching and fixing it, I would like to start off with the right foot this time. I am designing an application that lets the user see several...

That did it. Lovely :)

Hello dear readers, I am trying to implement a bound (to an RTF memo field) txtbox on a form and I can't find a workaround for an annoying default feature of access: my "enter" key keystrokes move to next record. I managed to prevent this behavior, at least, with a key capture routine, but I...

Why don't you concatenate with VBA? SQL would be useful to do this with recordsets, but I believe you could circumvent using SQL with the use of DLookup. Declare a string, concatenate your fields then use it as row source for whatever control you need in the report (textbox, likely?). Dim...

Didn't know about that one, thanks!

Have you selected "Form" from the combobox on top that lets you select the object?

I don't mind having the popups with the number of records that will be affected at an initial stage; also, I remember reading somewhere there was a difference between the two on lower-level compilation and execution - although I wouldn't remember what it is (some research will surely bring it...

I think using SQL would be more efficient and easier to control. You use the DoCmd.RunSQL method for that, so you can design your query in SQL and just pass it as a string to it. Dim mySQL As String mySQL = "UPDATE myTable etc." 'your update query 'DoCmd.SetWarnings False <- uncomment this...

Open your form in design view, in the property pane located to the right (if it's not there you can find the button to open it in the tools ribbon on top) select the "Events" tab, and find On Load -> click it -> you'll be brought to the VBA console. In it paste the code I gave you, although...

Harry, you can use the method I stated in an earlier post, and like Boblarson said you'd need to also use that code in the On Current event of the main form.

I would access the recordset of the bookings and prepare the string to use as the body of the e-mail. Something like: Dim db as DAO.Database dim rs as DAO.Recordset dim strBody as String Set db = CurrentDB() Set rs = db.OpenRecordset("bookings") if not rs.BOF and rs.EOF Then rs.MoveFirst Do...

I reckon a listbox or a datasheet subform would do well as there are going to be several calls for each ID on the main form. Or maybe I got this wrong. Let's just wait for the OP to clarify.