Forum: MS Access and FileMaker Pro Oct 11th, 2009 |
| Replies: 2 Views: 972 You could download and install the 2007 runtime but it would only let you USE the database, not dig into the design views. As mentioned by Gm Xtrm, you would need to have them save it into 2003... |
Forum: MS Access and FileMaker Pro Oct 10th, 2009 |
| Replies: 2 Views: 921 So you actually created an import specification which is called "File Import Specification?"
Perhaps if you haven't figured it out yet and want to send me your database file and your csv file, I... |
Forum: MS Access and FileMaker Pro Oct 10th, 2009 |
| Replies: 1 Views: 917 I think this (http://www.utteraccess.com/forums/showflat.php?&Board=48&Number=1634292&page=1&view=collapsed&sb=5&o=all&fpart=1) may be what you're looking for. |
Forum: MS Access and FileMaker Pro Oct 10th, 2009 |
| Replies: 5 Views: 952 I would also say that you need to
1. Be using split databases
2. Have each user using a copy of the frontend on their machine.
This is the way all multi-user databases should be done... |
Forum: MS Access and FileMaker Pro May 25th, 2009 |
| Replies: 2 Views: 953 Tab controls are interesting in that you rarely need to do anything at all with them or reference them. In your case you need to set focus to tab 5 and then refer to the subform on subform. You... |
Forum: MS Access and FileMaker Pro Jan 3rd, 2009 |
| Replies: 13 Views: 2,838 Perhaps you would like to use Microsoft's free Visual Web Developer. It is the free, limited edition of ASP.NET.
... |
Forum: MS Access and FileMaker Pro Dec 27th, 2008 |
| Replies: 13 Views: 2,838 That doesn't answer my question (but it is likely what you have isn't compatible with Vista although we won't know unless we can get the version).
Plus, it isn't the way it works. You have to... |
Forum: MS Access and FileMaker Pro Dec 27th, 2008 |
| Replies: 13 Views: 2,838 There is no "business edition" of Visual Studio. There is Standard, Professional, and Enterprise.
But I was asking the VERSION LEVEL: 2002, 2003, 2005, or 2008 If .NET
If it is another type... |
Forum: MS Access and FileMaker Pro Dec 26th, 2008 |
| Replies: 13 Views: 2,838 Which version do you have? |
Forum: MS Access and FileMaker Pro Dec 19th, 2008 |
| Replies: 13 Views: 2,838 That's not a "quick" thing to be able to do. You need to go learn how to use a programming language if you want to do this and do it so that it is secure.
See here for free tutorials:
FunctionX... |
Forum: MS Access and FileMaker Pro Dec 19th, 2008 |
| Replies: 5 Views: 1,070 Sounds like the assignment may have been misunderstood. But since we don't have the assignment (nor access to the instructor) we can't verify that.
If what you are saying is completely true, the... |
Forum: MS Access and FileMaker Pro Nov 18th, 2008 |
| Replies: 5 Views: 2,231 You are missing a .Form between the subform (actually, you need to make sure you are referring to the actual subform CONTAINER control that houses the subform on the main form) and combo and since it... |
Forum: MS Access and FileMaker Pro Nov 18th, 2008 |
| Replies: 5 Views: 2,231 So what is your current code in the After Update event of the first combo? |
Forum: MS Access and FileMaker Pro Nov 16th, 2008 |
| Replies: 5 Views: 2,231 What do you mean by you want the other combo box to have a selected choice? Do you mean that you want one value to be available in the second combo based on the first selection, or SEVERAL possible... |
Forum: MS Access and FileMaker Pro Oct 17th, 2008 |
| Replies: 3 Views: 1,181 Check out my sample here:
http://downloads.btabdevelopment.com/Samples/dates/ReportAndForm.zip |
Forum: MS Access and FileMaker Pro Oct 5th, 2008 |
| Replies: 8 Views: 15,716 The short answer is NO, you cannot do this the way you are wanting. You've been given what IS possible by kb.net. You CANNOT, under any circumstances, make an EXE file out of an Access database or... |
Forum: MS Access and FileMaker Pro Aug 5th, 2008 |
| Replies: 1 Views: 1,943 Not sure what you are actually doing. Are you wanting to export the data from Access into SQL Server 2005 Express?
If so, you should be able to use the (on the EXTERNAL DATA Tab) EXPORT > MORE >... |
Forum: MS Access and FileMaker Pro Jul 22nd, 2008 |
| Replies: 2 Views: 4,569 Encapsulate the field name in square brackets
[Parent UUID]
and in the future do not use spaces in field or object names as it simplifies things if you don't. |
Forum: MS Access and FileMaker Pro Jul 13th, 2008 |
| Replies: 6 Views: 6,984 Well, at least you got something working the way you wanted. Good to hear :) |
Forum: MS Access and FileMaker Pro Jul 13th, 2008 |
| Replies: 2 Views: 2,841 Why not just save the union query and use it in another query for your calculations just like using another query. |
Forum: MS Access and FileMaker Pro Jul 11th, 2008 |
| Replies: 6 Views: 6,984 What is the code that you currently have tried? |
Forum: MS SQL Jul 6th, 2008 |
| Replies: 1 Views: 1,866 I personally have always used a DTS package to do this (SQL Server 2000) |
Forum: MS Access and FileMaker Pro Jul 1st, 2008 |
| Replies: 2 Views: 2,520 Since this is 19 days old, you probably already got an answer elsewhere or figured it out, but here's a sample that might help:
Cascading Combo Sample... |
Forum: MS Access and FileMaker Pro Jul 1st, 2008 |
| Replies: 2 Views: 1,088 You would likely need to use subforms, especially if there are any one-to-many relationships. |
Forum: MS Access and FileMaker Pro Jun 23rd, 2008 |
| Replies: 5 Views: 1,466 Oh, I didn't notice it was yours :) |
Forum: MS Access and FileMaker Pro Jun 23rd, 2008 |
| Replies: 2 Views: 3,572 The answer to your original question as to why the query wasn't working is that you never gave it a WHERE clause to limit what it was doing. |
Forum: MS Access and FileMaker Pro Jun 23rd, 2008 |
| Replies: 1 Views: 1,318 Split the database and give each user a copy of the frontend. Multiple versions working in the same db file can only lead to corruption, as well as behaviour you describe here.
See here for more... |
Forum: MS Access and FileMaker Pro Jun 23rd, 2008 |
| Replies: 5 Views: 1,466 You really need to split the database and have each user have a copy of the frontend on their machine. See here for more about that:
http://members.shaw.ca/AlbertKallal/Articles/split/index.htm
... |
Forum: MS Access and FileMaker Pro Jun 23rd, 2008 |
| Replies: 1 Views: 1,218 Check out my sample here:
http://downloads.btabdevelopment.com/Samples/listbox/SampleSelectReportFromForm.zip |
Forum: MS Access and FileMaker Pro Jun 23rd, 2008 |
| Replies: 2 Views: 2,083 I'm using this one (actually the Access 2007 version) http://www.amazon.com/Beginning-Access-2003-VBA-Programmer/dp/0764556592/ref=pd_bbs_sr_2?ie=UTF8&s=books&qid=1214204228&sr=8-2
To teach a... |
Forum: MS Access and FileMaker Pro Apr 15th, 2008 |
| Replies: 1 Views: 3,345 The very first thing you are doing wrong is using LOOKUPS at the table level. Wrong, wrong, wrong, wrong, wrong....Can you tell I think it's wrong?
See here for more info about that:
The Evils... |
Forum: MS Access and FileMaker Pro Apr 13th, 2008 |
| Replies: 2 Views: 4,677 To add a form header or footer you can go to VIEW > FORM HEADER/FOOTER
or
VIEW > PAGE HEADER/FOOTER |
Forum: MS Access and FileMaker Pro Apr 12th, 2008 |
| Replies: 7 Views: 5,341 Not to disparage your attempt at a solution MidiMagic, but doing that would not solve the problem of creating a database program without the Access Interface. The questions I have about your... |
Forum: MS Access and FileMaker Pro Apr 11th, 2008 |
| Replies: 3 Views: 810 It's possible your auto updates updated your Access 2003 to Service Pack 3 and that has some wonky things going on with it. If you find yourself on SP3 be sure to apply the Access 2003 Post SP3... |
Forum: MS Access and FileMaker Pro Apr 8th, 2008 |
| Replies: 7 Views: 5,341 There are some third party tools out that will help you convert an Access app to VB or VB.NET but you really can't just "convert" an Access application to an executable.
If you are using Access... |
Forum: MS Access and FileMaker Pro Apr 7th, 2008 |
| Replies: 7 Views: 2,802 We weren't talking about a form. We were talking about a function. You should probably post a new thread for your questions. |
Forum: MS Access and FileMaker Pro Apr 1st, 2008 |
| Replies: 7 Views: 2,802 I guess you'd have to add an:
If dblNumber 1 = dblNumber2 Then
FindLargestNumber = dblNumber1
End If
or you can assign it whatever value you want. |
Forum: MS Access and FileMaker Pro Apr 1st, 2008 |
| Replies: 7 Views: 2,802 This is roughly what you want. Don't know what you want for the result so I returned the value that was the largest.
Option Compare Database
Private Sub cmdCompare_Click()
MsgBox "The... |
Forum: MS Access and FileMaker Pro Feb 5th, 2008 |
| Replies: 5 Views: 9,041 Yes, you would do similar to what was shown for the report but base the criteria of the recordsource of the other form as shown above. |
Forum: MS Access and FileMaker Pro Feb 5th, 2008 |
| Replies: 1 Views: 1,493 Check out this report sample here on my site. It shows you how to set the criteria for reports from a form:
http://downloads.btabdevelopment.com/Samples/combos/FormSampleFromMultipleCriteria.zip... |