Search results

So do I just need storage to contain the back end and no software? In other words, can I just upload the database back end file to the remote storage, and then the Office 365 on each laptop handles the Access queries and such? Thanks.

Thanks for all of your responses. I should have been clearer. People will have desktops and/or laptops, which will be Windows based with Office 365. Don't want the expense of purchasing a server that all can share, or the headaches of maintaining one. So, the question would be, what's best...

Small start up company with no PC's, server, etc. wants to subscribe to marketing data providers and develop own Access/SQL based marketing solutions. What's best way to get needed computer resources (e.g., host computer, MS application software, storage, online access, etc.,) short of buying a...

Thanks to everyone. I found another solution in another thread that I posted.

Thank you so much. I think I have it working now.

Thanks arnegp, but I don't want to set criteria for f7. The t1, f1 are names I'm using in this thread. My SQL uses the actual table names.

Changed syntax to: Like '*" & Me.[DEA] & "*' " and fixed syntax and missing parameter errors but : Set rs = db.OpenRecordset(strSql) returns nothing to screen.

Thanks. t1, f1 simplified for thread. Tried your suggestion on adding dq's and got compiler syntax error. Also checked for correct textbox name.

Thanks for your help. No compiler errors, but error 3061, too few parameters, expect 6, with both [Forms]![SearchF]![f1] and Me.[f1].

Trying to construct an sql string that will be used in VBA to select records from a table. I cannot figure how to use the wildcard character. Compiler does not like "*" and converts to " * ". Have also tried "'*" (double, single, asterisk, double), but can't get around compiler treating ' as...

Thanks for reply. The query is a select query that I created using Query Design. On the Form, I have a button that runs that query. The recordSource is a table and the form is unbound. Does that make sense? Like I said, I'm pretty knew to forms.

Hi again. I'm new to forms design. I've created a Form that accepts multiple field inputs and the Query that uses those inputs to select records into a datasheet view. When I change the parameters on the Form, the query does not update the resulting datasheet. I have to close the query...

Thanks Arnelgp. Your code seems to work fine. I'll test with it and will probably go with it.

Thanks Husky. Function is called by macro as 'FileLines = SplitFileIntoLines(filename)'. If I remove 'On error resume next', first pass gives 'Out of memory' error on 'TotalFile = Space(LOF(FileNum))'. Second pass gives 'Out of memory' on 'Get #FileNum, , TotalFile'. If 'On error resume next'...

Thanks. 1) The two lines after End Function are code lines in another module that calls the 'SplitFileIntoLines' function. 2) I'd like to run it repeatedly because I'm testing the code in the other module and do not want to close Access each time I run a test. 3) I've MSGBOX'd the variables in...

Following code works for smaller .txt files (e.g. 10mb). But for large .txt files (e.g., 120mb), it only works once. Then must close and reopen Access to have it work again: Function SplitFileIntoLines(PathFileName As String) As String() FileNum = FreeFile Open PathFileName For...

Got table create date as follows: Dim dbs As DAO.Database Dim tdf As DAO.TableDef Dim MDBFullPath As String ' Open the Access database in shared mode (False) and read-only (True). Set dbs = DAO.OpenDatabase(MDBFullPath, False, True) For Each tdf In dbs.TableDefs...

Thanks again. I actually found another way, much simpler, to get the table create date. 'dateCreated' is a table property that is easily gotten without going through MSysObjects.

Galaxiom, thanks. But could you please elaborate? I tried to set up a new connection, but the MSysObjects table would not expand to its columns in the query wizard.

Thanks. So, I can retrieve a table name into Excel, but to get to a record within that table, I have to connect to the database? Is that right?