Recent content by ToddNYC

After spending days with scripts and work-arounds, I found a very easy solution to this access/excel problem. Download OpenOffice (it's free!) and use Calc, the spreadsheet program. It offers most of the same functionality as Excel with out many of the problems. It may easily solve your...

I'm not making much progress here. Am I thinking about this the right way? Am I trying to write to the 2nd table ("tblOtherTable") the duplicate events, changing only the specific date of that event. And have the code keep looping until the event date = end date? This way if I enter an...

Thanks Paul for the quick reply and pointing me in the right direction. I'll play around with the code you suggest and see where I can get.

I am looking to have entries made to the table based on a date range and can't figure out where to begin! Hoping you can point me in the right direction. I have a database of events and most repeat daily, weekly, etc. When I enter them into Access, they go in as a single entry with a start and...

Thanks Bob for the reply. The button was created by using the controls wizard, and I believe it is a macro. Button action is On Click [Embedded Macro]. I don't know how to copy contents of a macro, but here is the code: On Error go to next macro name RunMenuCommand command Select Record If...

Hi -- My "duplicate record" button on my form has started to act very strange, and I'm not sure what I did wrong! I created it using the wizard, and it worked for a long time, but now when I use it the following happens: (1) An empty record is created with a new ID, and (2) it overwrites...

Thank you Paul for the quick reply.

Hello - I think I am missing something very basic here and hoping someone can point me in the right direction! I have a table of several hundred items. Each of these items has a category code to make the data easier to manage. (This category code links back to a separate table. So in the...

Thanks for your guidance. I was able to use your advice (and terminology) to find a great tutorial (http://www.youtube.com/watch?v=nszRT3nRUMU) to help along with some other posts on this site to help me figure it out. Thank you all for providing such excellent support to a beginner like me!

Thanks for the feedback.. I am going the "old fashioned way" Pat describes, and have successfully created an association table (pointer table? not sure of correct terminology) to allow me to store multiple values against a single ID. My question is about getting the data from a form against the...

Hi, thanks for the reply. I was hoping to use the wizard, but it does not give me the option to set up for multi values. The only way I can get it to do that is if I make it a look-up field at the table level, which I've been told not to do. So in this case, is it OK to have a look up field...

I'd like to add a multi-value combobox to my database. I understand I want to avoid table-lookups, so I'd like to add it to my form, but can't figure out how. I've been unable to locate a post, article or tutorial. I must be searching using the wrong terminology. Can anyone direct me to...

Thank you for your advice. I'll take a look through and see if this gets it working.

Here it is... hope it's not too shockingly messy! I am trying to accomplish the following: In Query "Upload_Events", the last column (Expr1) is my attempt to take the data from field "primary_event_type"and replace the comma with a semicolon. It is now giving me the ID fields, but I am...

I've made some progress... if I use: Expr1: Replace(DLookUp("primary","tblEvents","guid = " & [guid]),",",";") I do get the values I want...almost.... I get the ID number of "primary" values. Would you know how I get the field value?