that's very kind of you, yes of course. do you need my private email address?
thanks
Kevin
Kevin Wilcox
Last Activity: Nov 16 '08, 08:08 AM
Joined: Sep 12 '07
Location:
-
Hi
Yes, you can certainly open another form or do whatever else you want based on the result of a recordcount, i.e. recordcount = 0.
KevinLeave a comment:
-
Sadly that doesn't work either. Refreshing does have an effect in so far that the screen will flicker as the value changes, but at best the screen will white-out within the affected area the repaint once I release the mouse button. I'm wondering whether I might be able to solve it by using a mousedown event on the form coupled with timer and an on_click on a dummy button. I don't know enough about scroll bars to know what I should be able to get...Leave a comment:
-
Hi Fishval
that doesn't seem to work. can I check that I'm coding this right?
...Code:Private Sub ScrollBar1_Change() On Error GoTo proc_error Dim ScrollVal As Integer Dim DateFactor As Integer ScrollVal = Int(Me.ScrollBar1.Value) Select Case ScrollVal Case 52 DateFactor = 0 Me.txtWk1 = RefDate Case Is < 52 DateFactor = (52 - ScrollVal)
Leave a comment:
-
Hi Mattia
Obviously there are various how-to's though I'm not sure how they hang together as a beginners guide as I just dip in whenever I think one might help. What I can point you towards is this link http://c85.cemi.rssi.r u/access/Books/ABA/aba01fi.htm#I33 and http://www.mvps.org/access/
On to the immediate issue. What you've done is make frmTasks a subform within frmProjects. This remains frmProjects, not frmUnique....Leave a comment:
-
Hi
I'm assuming you know how to create a form, and how to populate combo boxes.
Note that the values in your combo's must match those in your queried tables. In situations like this, I usually populate my combo's by using 'totals' type queries off the relevant tables rather than by entering the values by hand, e.g. create a query to count how many of each status type exist in the table, and use this as your combo list....Leave a comment:
-
Hi
If you google 'ms access custom menu bar' you'll find no end of tutorials, samples etc.
IMHO, if you're able to write macros in access or excel you'll almost certainly be able to quickly grasp the basics of writing code in access, so give it a go! Personally, I learnt the basics by recording macros in excel, then looking at how they worked and tinkering with them.
KevinLeave a comment:
-
Hi
Setting a password should block unauthorised access to all the objects. If you don't want to do that because users need free access, perhaps split it into front end / back end and password protect the back end. If you want to block authorised users from easily accessing the databse window, look at disabling the bypass keys (google DisableBypassKe y). But ultimately you may need to use mde's.
HTH
KevinLeave a comment:
-
Hi, this post might help.
[HTML]http://www.microsoft.c om/office/community/en-us/default.mspx?&l ang=&cr=&guid=& sloc=en-us&dg=microsoft .public.access& p=1&tid=648B38E 5-8BF1-411B-B70A-4DFBA300B0A4&mi d=648B38E5-8BF1-411B-B70A-4DFBA300B0A4[/HTML]Leave a comment:
-
Hi
How about using the 'on updated' event of the calendar control? i.e.
KevinCode:Private Sub Calendar_Updated(Code As Integer) text box 1 = me.calendar text box 2 = me.calendar 'and so on, using the correct names for your controls End Sub
Leave a comment:
-
Hi
use the 'after update' event of the combo to update the destination field. you could actually use that destination field on your form instead of the unbound box, and perform the calculation within vba.
example:
you could use the If ... then... end if method but I prefer to use select case for options like this, apparently it executes more quickly and in any case I find it easier to write
...Leave a comment:
-
Hi
It sounds like you could use a separate table to capture the data; which would have the taskID, the hours, and the w/ending date. I'd also have things like the updated date and userID. I think I'd capture this by having the user click a 'save' button on the record (presumably a continuous form?), and on the 'onclick' event for this, append the taskID, hours and wending to that table. I'd get the w/ending value by cross-referencing...Leave a comment:
-
Hi
This sounds like a risky way of doing things! Sorting the table won't change the record numbers, just the order in which they are displayed. Much better to have an explicit link between the records in each table, e.g. include a playerID in tblNumbers, which corresponds to their recordID in tblMain. (Personally I'd also rename the recordID field to PlayerID, or vice versa, just to make it obvious, and link them in the relationships...Leave a comment:
-
posted in error, removedLeave a comment:
-
Hi
This sounds like you don't have any relationship set up between the tables or within the queries, (or if you have, that it needs looking at) and consequently the third query is returning every record in table 2 for each record in table 1, and vice versa. There's a good tutorial on relationships on this site, worth looking at that first.
HTH
KevinLeave a comment:
-
Hi
Assuming you've passed the query name to the variable stDocName and so on, and the query has fields in it, I can't see anything obviously wrong with what you're doing, but here's some code I've used to export tables, from a list within a listbox [lstTableNames], which definitely works. Note that this also gives the user the option to export to another access db, by selecting from a combo [cboFormat], so you'll need to edit rather...Leave a comment:
-
Hi, there are a few examples of workdays functions around if you google ms access workdays function, you could also look at [HTML]http://www.mvps.org/access/datetime/date0012.htm[/HTML]
Also here's a couple of functions that I've borrowed and/or reworked a few times. From what I remember I had problems with the first one, where I couldn't get it to infallibly return the correct number of days (when compared against manual counts),...Leave a comment:
-
refresh screen during scrolling
Hi
I'm trying to emulate, within access, the gantt chart timeline / task planner aspects of ms project. Creating the chart on the form has been easy enough; I use a series of unbound text boxes in the header to show the week numbers, with correlating unbound text boxes in the detail section of a continuous form to calculate a series of values for each task which, where these match the value in the header text box will change the colour... -
have you tried removing the acReadOnly off the end? Whether or not the query will fail depends on the table settings, i.e. whether it'll allow duplicates in the relevant fields. But in any case it sounds like you might want a facility where the user confirms their selection is ok, i.e. a confirm cmd button
HTH
Kevin...Leave a comment:
-
I think you have to use code to take advantage of a multi-select list, and that without this it'll only ever return the first value selected. At least, that how I use them. Typically I build a query string within the AfterUpdate event for the listbox, and then e.g. set the record source of a form or control using that string, or replace an existing query (i.e. the record source for a report) with this new definition using querydef. My AfterUpdate...Leave a comment:
No activity results to display
Leave a comment: