Search results

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?

Thanks John for creating the example for me! Makes sense, but I still get error "The multi-valued field '[primary]' is not valid in the expression 'Replace([primary],",",";")'. The problem is probably that the field "primary" is created via a combobox. So sorry if I'm missing something...

I haven't been able to get replace to work for me, can you set me straight? I am using Replace() in a query. One field is pulling in multiple values from a table (ie. "Pontiac, Ford") and I'm trying to use a separate expression to replace the comma with a semicolon but can't get it to work as I...

Thank you! I'll play around with that to try and get it to work. I appreciate the help! Todd

Is there a way to have multiple selections from a dropdown combobox writtin to the table with a semicolon separating them rather than a comma? So when I select multiple items it saves as "first item;second item;third item" instead of the default format of "first item, second item, third item"...

Thank you so much for the quick reply! It does work perfectly in this example, I am still trying to integrate it into my larger database and write to the tables etc.. I'll keep banging away at it and I appreciate your help and time. Todd