Search results

Thanks Spike, Tablet...I haven't purchased any for this purpose yet. The only thing I know of at this point is I'll need windows 8 or 8.1, with bullet proof cases, and as I'm buying 7 of them, I'll need to keep the price reasonable, say under $500. Any Recommendations?

CJ, Don't mean to hijack the thread, but I have the same questions....In my case, I would be using Access 2010 runtime on the tablets, to run a "read only" app I would create to read information off our ERP system database. We are a manufacturing company, and this would be used on our shop...

VBAInet, Yes, that was me. I'm happy to say I've been able to accomplish that with the above code. I'm using a ODBC Driver for google apps from Cdata, which seems to be working nicely. There is a limitation with column widths (254 I believe), but I don't think this will affect me. Thanks...

Good Morning Gentlemen, Sorry for the delay, but I'm not a full time programmer, and my other duties pulled me a way for a bit. I'll attach what I've come up with so far, which seems to be working. Basically, I put together a recordset for the query I'm browsing, and a recordset to...

I have an instance where I have 3 recordsets I need open at one time. Let's say Query A, then table A and Table B that I'm populating. So, Recordset #1 loops through qryA, then based on a Logical test, I need to either enter records into tblA (rs2) or tblB (rs3), depending on the logical...

Thank you VBAInet for your input. After a fresh start this morning, I tried to utilize a simple append query through the interface, and they appended fine. I'm thinking of going in the following direction on this project instead. Using VBA, build a temp table and populate it with the...

Thanks everyone, I have access 2010 and 2013 available to me. While we're at it, does 2013 offer any additional web options? I've looked at the web databases in the past but was kind of put off, by the data structure and that you can't use VBA.

So, this afternoon I had a webinar, where a software development company was showing me what they were capable of. The particular application they were showing me was all cloud based, built as a full ERP system, in Silverlight. What really blew me away was how modern and smooth all the...

Ok Great Thanks! I'll start with this on Monday and let you know how it goes!

I've been out of VBA and access for months now, just hopping in to accomplish a quick little application, and I'm stuck.... I'm trying to use an ODBC adapter from Cdata to push information to a google calendar. I've got it hooked up, and I can read data within a DAO recordset, but .addnew...

I used to be able to do this...about 2 years ago. It's amazing what you forget when you don't use the skills.... I have a table I'm trying to query information out of. Key fields are below: RecNo (Key) ParentRecNo Description I need to have a "record" in the query show both the...

OK, I'll resurrect this one more time.... Did you have any luck? I'm trying to re-establish the links to an SQL db. I want this to be a dsnless connection, as I'm hiding the username and password for the db from the users, and this will be deployed off site. I did open up the mysobjects...

Oh yeah, and it will work with currentdb....but I don't want to do that. You see, I'd like to make this a unique connection, before the linked tables are refreshed. If the login fails, then the db closes before anything can be written or changed. I'm open to ideas :-)

Ok guys, my apologizes, I thought this was going to be a quick "duh" kind of answer. Here's the code: Private Function ValidateLogin() As Integer '==================================================================== ' Comments: Compares both the Hard drive code, and the username and...

Can anyone tell me what is wrong with this? Set dbs = OpenDatabase("", Options:=dbDriverNoPrompt, ReadOnly:=True,"Description=acsSQL;DRIVER=SQL Server Native Client 11.0;SERVER=REMOVED;UID=gb;PWD=REMOVED;APP=Microsoft Office 2010;WSID=GARY-PC;DATABASE=CabProgram;") When I try in VBA IDE, it...

Hello, I'm trying to use a timestamp data type in a table to tell compare two tables (local and cloud) to determine if one has been modified. However, I can't seem to get the field to populate. From what I understand (not much!) the field is supposed to auto-populate when a record is...

I have a similar issue I have yet to solve. I'll be following the responses.

OK, First off, thanks for taking a look at this. Please realize that I'm a newbie at setting up an SQL db, and I don't know all the in's and out's. I have created an SQL database through SSMS that I have now placed in hosting on a Godaddy account. I have connected to this...

Thank you Pbaldy, I see your point. I wonder if I should consider a local temp table. something that loads that complete table (30 records or so) upon startup, and deletes them all on closing. If I were to go this route, is it ok to leave that temp table in my accde front end, or do I...

I have an application I'm building where there will be a local front end, and an MS SQL Server back end, hosted in the cloud. In this application, I have one continuous form that has a high definition picture for each record, there are 30 records total. When I had the back end on my local...