Sorry about that! I misunderstood what you were trying to do, I thought the main form you were talking about was for displaying data only, not that you also wanted to use it for data entry. (Doh!)
Glad you found something that works! ^_^...
Khriskin
Last Activity: Feb 21 '08, 07:54 PM
Joined: Feb 7 '08
Location:
-
You'd need to create the form first, then you can use the DoCmd.OpenForm to open it, just like an ordinary form. Make sure you set the pop-up form to Pop Up (opens in front of other windows), Modal (keeps focus until closed), and Data Entry (new record entry only).
Also, you'll need to do some basic error trapping on the pop-up form to make sure the users don't close it before all the information is gathered (as well as put in valid...Leave a comment:
-
I'm a little confused as to what you are trying to accomplish. As a disclaimer, I work in Access 2000 and 2003, so 2007 may have features I don't know about. However, the code you included in the post doesn't seem to do what you are looking for.
The code is setup to create a new record within the table, but it does so using variables that are not defined (strStringVaria ble, dteDateVariable , etc). Thus all of the variables default...Leave a comment:
-
Darnit. *sighs* Oh well, at least the workaround works for now.
THANKS! ^_^...Leave a comment:
-
Ah, if only I could wean them off Excel so easily... *wistful sigh* Actually, that is my end goal (I'm already prying them out of Lotus slowly but surely), but it'll be another year or so before I will be able to convince them the database is easier. :P...Leave a comment:
-
My mistake about the homework, sorry about that! ^_^;; <-(sheepish look) ((baa!!)
I use isnull(DLOOKUP) combo as a fast way to check and see if a query returns empty, but there are probably better ways out there.
isnull(DLOOKUP( "[Field1]", "tblData")) will spit out true if there is no data in tblData (assuming you change [Field1] to a field the query returns) and false if there is. Since the query...Leave a comment:
-
I think I have a similar situation to what you are describing, but I'm not quite sure how you have your databases setup.
I have the back ends of my databases sorted on the server (which bogs down quite a bit) and the front ends stored locally. In order to reduce the load on the server I have several of the tables that are not changed by the front ends stored as local tables within the front end programs. Every time the local program...Leave a comment:
-
Ah, I think I see the problem! ^_^
See line 3? In that line you are telling the query to look for matches between field [Result] and Sum([SumOfxWIN])/Sum([CountOfnDIST]). What you want to do is set [Result] to that value, not look for a match. Right?
What you need is this added to the SELECT line:
Sum([SumOfxWIN])/Sum([CountOfnDIST]) AS Result
So what you would end up with is:
...Leave a comment:
-
From what I understand you have an existing query called [HTR BY RANK BY TRACK] that has two fields [SumOfxWIN] and [CountOfnDIST].
You want to sum these two fields again and then divide the sum of [SumOfxWIN] by the sum of [CountOfnDIST], correct?
If so, you could write expression for the third field as:
[UnnamedField] : ([Sum Of SumOfxWIN] / [Sum Of SumOfnDIST])
Or as:
[UnnamedField] :...Leave a comment:
-
(Note: I'm keeping this vague as it sounds like you are posting homework questions (per your other post). If this is not the case, I apologize!)
Are you checking for duplicates against just [dateOfClass] and [time], or against [instructor] as well?
If it's just the first two, an easy check would be to use a DLOOKUP for one of the variables using the other one as the filter. Then you could check the DLOOKUP output to...Leave a comment:
-
As I understand it, you are currently have the following query created:
The first returned value in the query is a SUM of the field [Orders]
The second returned value in the query is a SUM of the field [Count]
So the results of the query would be:
[SumOfOrders]
[SumOfCount]
Now you want to add in a third field:
([SumOfOrders] / [SumOfCount]) * [SumOfCount]...Leave a comment:
-
How do I import data from a locked Excel file?
I have searched the forums (as well as msdn and other websites) and have not been able to find a solution. Any and all suggestions would be greatly appreciated!
Problem
I have two Excel 2003 files from which I need to import/pull data, however these two files are almost always open/in use by the Scheduling Department.
Current Workaround
Currently I have a warning on the user interface that prompts the user... -
Okay , here's a rough outline for you. It should give you general idea of how I was thinking of handling the problem, but please keep in mind I'm by no means an expert. ^_^;; <-(sheepish look) ((baa!))
1. I'm assuming you're importing the original text file into Access as a table.
2. I'm naming this table [tblData]
2a. I'm assuming [tblData] has two fields (in this mockup), [CustID] and [CustName]...Leave a comment:
-
- My previous attempt at a guess is humbly withdrawn, for lo, a much better answer appears below. ^_^Leave a comment:
-
This is something I have implemented for several of the databases, it filters by user and access level as to what they see and what they can edit. The problem with combining them into one 'Evil Overlord' database would be it would be a pain in the neck to document clearly enough that if I got hit by a bus the company wouldn't suffer.
I've got an Inventory Database, a Production/WIP Database, a Sales/Forecasting database, a Scheduling...Leave a comment:
-
This is where it gets a little complicated, and the point where I wish I had a whiteboard to doodle on. ^_^;; *sheepish look* (baa!)
1. The back ends are all stored in one folder that is accessible to everyone. (\\Fileserver\D atabases)
2. The front ends (master copies) are in another folder that is also accessible to everyone, but which is read-only to everyone but me. (\\Fileserver\D atabases\Active Copies of UI) This...Leave a comment:
-
Access 2003 - How best to push front end updates?
As a warning, I'm self-taught so I have a bad habit of brute-forcing things out of ignorance. I've done some searching online and haven't found a solution, so I figured it couldn't hurt to ask you kind folks if there was a better alternative.
PROBLEM
I have multiple front ends that are updated on an almost daily basis as needs change (or I find problems). I need an easy way to push out new local copies of the front ends to multiple... -
It would depend on what you need the program to do. My first inclination would be to suggest getting a list of the unique IDs (by query) and then looping through them (using a recordset). On each loop you could set the export query to filter by the current ID and kick out a csv file.
However I see that you are opening the file right after you create it, did you want to do this for every file created?
Let me know if you...Leave a comment:
-
Assuming that you have [frmContracts] open at the same time as [frmInvoices], then you can trigger a refresh of the first form in the close function from the second form:
[Forms]![frmContracts].Requery
You can also requery the Total amount, assuming it feeds from a query:
[Forms]![frmContracts]![varTotalAmount].Requery
Hope that helps!
EDIT: Sorry, forgot to include you can...Leave a comment:
-
DoCmd.SetWarnin gs False 'will turn off the popup warnings
DoCmd.SetWarnin gs True 'will turn them back on
Makes sure you turn them off when necessary as it will disable /all/ error and warning messages!Leave a comment:
No activity results to display
Leave a comment: