Search results

Thank you everyone for your responses so far. Here is where I'm at: I've been able to figure out item 1 through conditional formatting...However, this cell is being highlighted to draw attention to the user to fill it in. Once they fill it in I would like to clear the highlight. wiklendt...

I'm fairly well versed in Access VBA, but I have a particular project that is MUCH better suited to a simple excel spreadsheet. I've never really done Excel VBA, and am wondering how to go about it. Does Excel VBA have "Event"s that run the code? Below is a list of a few tasks I'd like to be...

Ok, I'll Bite....I'm with you on this one, but for me, I haven't found anything else that would be greener. Truth is, that programming is only 10% of my job. For me to change to anything else would require a lot of nights trying to become proficient in another language/platform. I'm not...

Not sure I understand the "doesn't support automation" part. But I can tell you just yesterday I was working in VBA and making access copy and rename a master excel (.xls) spreadsheet, then opening it and population certain ranges with data. And this was with Access 2013...

Well, I called Microsoft....and after 20 minutes of my life past, and talking with 5 different people, I ended with the same result. No way to get a 2010 version. They suggested I find a retailer that still sold it...However, I've also heard they "request" the old versions back from...

So, I just updated to a newer computer. This computer has Access 2013, my old one has 2010. I have some FMS add in's for access 2010 that I've been very happy with, and I'm missing them in 2013. Also, I seem to prefer the 2010 version for my desktop applications. Is there anyway to obtain an...

Has this been proven with MS Access Runtime on the Front Ends?

Plog, Thanks for the update...I took a quick look a php last night, but as an amateur programmer, I don't think my time is best spent learning this language. I won't ever use it enough to gain proficiency. Heres an interesting video on Access 2013 and it's web apps....looks like it was...

Thanks Guys.... Spike, I actually did read the sticky. It just doesn't really give any feedback as to whether or not the actual "Web" databases in Access 2013 and 2010 are actually being utilized by anyone...or how they are working. The "SQL db in the cloud" Route seems like a good...

OK, so it's been four days.....Most times I get a response in minutes off of this site. I guess I should take that to mean that no one is using these new Access "Web Databases"? I've heard negatives on them such as not being able to accomplish what is needed with the limited macros.

I'm trying to decide at the fork in the road between two paths....My friend needs help with a simple database. This will have at least two tables, with a parent child relationship. It is for file storage. Basically this will locate file boxes on a shelf, and add new records as he adds boxes...

On Second thought.....This interface is only for browsing, not editing... Is there a way to put a "sub report" into this form, as I'm assuming it will read better?

I love this forum! thanks to both of you who responded in such a short amount of time. gemma: I coded your suggestion, and think it's a fair compromise. I'm ultimately creating this particular app for a tablet, so I'll have to try it out. pbaldy: I did download that and try it out...

I have a "Notes" field that I have placed on a continuous Subform. I expect this field to grow and shrink as needed to be able to see all the values in a specific record on the subform. After some searching, I can't find an answer...Is it really that difficult? If someone can point me in...

Agreed! Thank you Jdraw. At the bottom of the article, it mentions not using wifi at all though.....is wifi not an option, even with the SQL BE?

oh jeesh :o I was able to get it figured out...that really opens the door! I've relied so much on Recordsets, I've forgot what an update query is capable of.... Thanks again!

See attached

Plog, This will be run by a VBA driven Event. I would just prefer a Query because I've been told they run faster than a recordset. I've never used an update query in this manner before. That is, Each record that needs updating finding the correct information based upon the cooresponding...

Hello, I have two tables, tblLog, and tblCalendarDump. They both have the following Fields: WorkOrderID, CalendarEventID, and CreateDateCalendar. tblLog holds records that are to include information pulled by tblCalendarDump. They both have WorkOrderID fields populated, so I need to...

Thanks guys! Forgot to mention that the back end is SQL and I'll only be reading records, so I'm hoping I'll be ok