Am I Looking To Do This Backwards?
Dec 22, 2005
I have an Access Database setup that sorts archery scores. I want to export a query to a specific sheet in an Excel file that is setup for playoff bracketing which has formulas that automatically advances the winner of a match to the next round.
Now my question is, am I looking at this backwards? Would it be easier to import the excel file into access? Or should I stick to exporting data to excel? I want this to be automated as much as possible to the user has to do as little as possible (ideally, hit a button and the bracketing pops up...)
If anyone has any ideas (or possibly some VBA code....;) ) please let me know.
Thanks
Steve
View Replies
Jan 2, 2007
Hi.
For years several agencies have used a database written and maintained in Access 97.
One adminstartor has both 97 and 200 on his computer and no problem. Until now, that is.
When I try copying a revised front end, and opening it, I get 'unrecogized database format' message.
My hunch i sthat said administartor accidentally opned the basck end with 2000 and converted it.
So, can the back end be unconveted/reverted back to 97?
Any other suggestions?
Russ
View 8 Replies
View Related
Mar 12, 2006
I have a continuous form based on a query.
The query is derived from three tables each in a 1 to
many relation to the next. (tables A, B, C)
So when I open this form (with filter A = 1) I expect to get this order:
A B C
---------
1 - 1 - 1
1 - 1 - 2
1 - 1 - 3
1 - 2 - 1
1 - 2 - 2
1 - 3 - 1
1 - 3 - 3
What I am getting is the records listed in the opposite order!
(1-3-3 on top, 1-1-1 on bottom)
Can anybody tell me why?
Thanks.
View 1 Replies
View Related
Mar 10, 2014
I really just want to get the recordcount of the recordset to display on my form.
Code:
Public Sub CallSP()
Dim cnn As ADODB.Connection
Dim rsSQL As ADODB.Recordset
Dim CmdSQL As ADODB.Command
Dim rsACCESS As ADODB.Recordset
[code]....
View 7 Replies
View Related
Jan 7, 2014
I used the code in the link below to get the login id returned on a form but I am having trouble now that I rolled out the database the code gives an error if the user has older than 2010 and even on a new machine that has access 2013 what is the best code to use? to return the log in id to a form?? without worrying about what version of access they have it wont be older than 2003. URL...
View 3 Replies
View Related
Mar 15, 2013
I would like to create a query that displays a date like this "20130315". Can this be done?
View 4 Replies
View Related
