Search results

I got external excel data into an access database. my problem is that it seems like the vbLF's are gone. I have to explicitly copy data from one cell of excel to access for the linefeed to show, 1 by 1. Do vblf's & memo fields not mix? Do vbcrlf's work out better??? HOW CAN I...

Since I didn't find out how to print in imm window,, I looped through a recordset of the field, and in the msgbox they appread just fine though they don't otherwise. I guess there isn't a problem after all.

in this expression where tblrecipes.categories like tblcategorias.categorias how do I integrate the asterisk? I tried a variety of ways, I either get a syntax error or 0 affected rows, currently the statement as is only gives results where the text contained in categories is all by itself...

I know this is an old post but how did the issue end up getting resolved as I have a similar issue. Thanks

the simplest way it seems I can pull this off is 1st adding a blank category for each recipe, then updating categories based on various criterias,,, and like you said for those missing probably assign them a none. as far as the other matters there really isn't an issue besides the...

in the back of my mind I imagined once I finished categorizing I'd have to address the none category. Now that I think of it, is there a function that would help that you can think of, or have used?

I just imported an excel into access. A column turned out to be a memo type field. I just noticed my line breaks didn't transfer over. Is there any way to control this or should I just go back to my original excel source and replace my vblf's with vbcrlf's? Or if I ultimately intend...

I'm nearly done with an action query that will make category associations. I have a table for the categories and another to relate from. My trouble is with the where clause of my insert into values expression. Lets say for example I have the following variants deep fry deep fryer...

while thinking of multiple people working on a single database over the internet I wonder which are either the most common ways to handle unstable internet connections. IMO it seems best to always keep track of the last update of a record so that if a user has disconnected while working on a...

thanks for the link, I did it in excel.

I was thinking about working with the excel file, copying a # column & nutritional data to a separate file, exporting to a csv, opening it back in excel with the ; delimiter and then adding the ; separated data back. Its all I can imagine to do that would work. That also seems like all I...

I have an excel for recipes I recently imported into an access database heres how the nutrition data field looks : 84 Calories; 3g Fat (36.5% calories from fat); 1g Protein; 9g Carbohydrate; 1g Dietary Fiber; trace Cholesterol; 81mg Sodium. Exchanges: 0 Grain(Starch); 1/2 Vegetable; 1/2...

though I originally didn't inted to do an action query with inner joins,,, I eventually figured out I had to use a several update selects since I reused a table many times in 1 table. thankfully thats over

I just finished a access vba project that puts brings together allot of different recordset data and sends an email. The way it achieves this is looping through the recordset and aggregating strings. I only used a certain amount of spaces & vbtabs to more or less mimick tabular data based on...

yes I hate the fact that I had to start with access and vba but its a great start! hello again

edit: will make another post for this

I changed up the arrangement of my database after thinking things. Instead of having separate tables for customers, suppliers and etc I made one table called tblCos, for simplicity. Whats wrong with this statement as I'd been pretty careful putting it together with excel cell functions. There...

Thank you!

Access doesn't support sql select but I also didn't run across an example where switch was used for anything other then setting string values. Can I do this: select order.[amount], order.[date], switch (order.[co type]=1, tblcustomers.[co name] as company name...

quite interested in ghudsons method. for reference I've run across these also, besides clickyes. http://www.add-in-express.com/outlook-security/ AWESOME TOOL!!!!!! If I ever need one I'll definitely pay extra and get this...