Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 85
Search took 0.01 seconds.
Search: Posts Made By: jeremy1048
Forum: Access August 1st, 2008, 10:20 AM
Replies: 2
Views: 1,297
Posted By jeremy1048
Clock

Hi All,

I am trying to find a way to create an audit system of auto entering of dates, however user's have a nasty habit of playing with the system and bios clock and therefore invalidating the...
Forum: Access July 28th, 2008, 10:36 AM
Replies: 1
Views: 1,012
Posted By jeremy1048
Unbound Forms

Hi All,

Can anyone point me in the direction of either in Wrox's books or someone else's for a tutorial in a many to many unbound form.

One Complaint many complainants each of whom can make...
Forum: Access July 4th, 2008, 09:33 AM
Replies: 4
Views: 969
Posted By jeremy1048
further to my last there seems to be a slight...

further to my last there seems to be a slight prob with that code in its working

I have the following input mask on the txtprpostcode box, just in case that may be a factor:

>La99\ 0LL;0;#
...
Forum: Access July 3rd, 2008, 11:20 AM
Replies: 4
Views: 2,200
Posted By jeremy1048
used to when the me.refresh line didn't work i...

used to when the me.refresh line didn't work i deleted it.
Forum: Access July 3rd, 2008, 11:05 AM
Replies: 4
Views: 2,200
Posted By jeremy1048
tried that one and it works fine for the future,...

tried that one and it works fine for the future, just not the overdue box
Forum: Access July 1st, 2008, 04:57 AM
Replies: 4
Views: 2,200
Posted By jeremy1048
conditional formatting

Hi all,

Got a novel or quick one for you. I have two text boxes on a form which have conditional formatting applied. The textboxes are unbound linked to separate DCount queries. The form as its a...
Forum: Access June 25th, 2008, 09:56 AM
Replies: 3
Views: 918
Posted By jeremy1048
i'd grab a copy of "access 2003 step by step"...

i'd grab a copy of "access 2003 step by step" first off to familiarise yourself with access. its the easiest book to learn how to play with access from. You should be able to get a good basic handle...
Forum: Access June 24th, 2008, 11:18 AM
Replies: 3
Views: 999
Posted By jeremy1048
hi serrano, yeah that's what i meant by: ...

hi serrano,

yeah that's what i meant by:

"I can stop it with making it deambiguous so that's not the real issue"
Forum: Access June 23rd, 2008, 09:07 AM
Replies: 3
Views: 999
Posted By jeremy1048
Novel bug, hoping someone can help

One of my old databases written in access 2003, which I am resurrecting and updating, has developed a rather novel bug which even with a breakpoint on the error trap isn't showing up as to what's...
Forum: Access June 23rd, 2008, 07:58 AM
Replies: 3
Views: 8,253
Posted By jeremy1048
what i tried was: ...

what i tried was:

.ListItems.Item(Counter).ListSubItems(4).BackColor = vbRed
.ListItems.Item(Counter).ListSubItems(4).ForeColor = vbWhite

that was the idea however it says property not...
Forum: Access June 23rd, 2008, 07:42 AM
Replies: 3
Views: 8,253
Posted By jeremy1048
I tried that and it gets kicked out on compiling.

I tried that and it gets kicked out on compiling.
Forum: Access June 22nd, 2008, 11:32 PM
Replies: 3
Views: 8,253
Posted By jeremy1048
Conditional Formatting a Listbox - refining it

I have found a method of doing conditional formating a listbox to the individual field using subitem code as follows (not the complete code however you'll get the entire idea as its copied from a...
Forum: Access June 18th, 2008, 11:05 AM
Replies: 3
Views: 1,061
Posted By jeremy1048
disregard problem solved

disregard problem solved
Forum: Access June 18th, 2008, 10:30 AM
Replies: 3
Views: 1,061
Posted By jeremy1048
nope none of those have really helped. Found...

nope none of those have really helped.

Found a solution to half the problem, now its just the last bit.

e.g. select * from tblcalls where contactid = forms!frmcontacts!contactid is the source...
Forum: Access June 18th, 2008, 04:46 AM
Replies: 5
Views: 999
Posted By jeremy1048
the table structure consists mainly of yes no...

the table structure consists mainly of yes no fields (around 100 with a total of 160 fields in all at the moment and ever expanding as the law changes) as its for checking the contents of a case and...
Forum: Access June 18th, 2008, 04:22 AM
Replies: 5
Views: 999
Posted By jeremy1048
yeah i tried it without the null a few months...

yeah i tried it without the null a few months ago. Unfortunately found I was getting numerous blank entries without the "is not null" in there. This then throws out the result
Forum: Access June 16th, 2008, 05:39 PM
Replies: 1
Views: 1,205
Posted By jeremy1048
the simplest solution, i can think of at the...

the simplest solution, i can think of at the moment, would be to have the record source of the subform being a query with the criteria equal to the combobox or list box that you are using for the...
Forum: Access June 13th, 2008, 11:07 AM
Replies: 3
Views: 1,061
Posted By jeremy1048
Tutorial text sought

Hi Guys,

I'm looking for a step by step tutorial exercise I can use to learn from, either from website or book which will show me unbound fields insertion into a listbox where the list box is a...
Forum: Access June 13th, 2008, 10:58 AM
Replies: 5
Views: 999
Posted By jeremy1048
SELECT TOP 67 PERCENT lkpqryarname.arname,...

SELECT TOP 67 PERCENT lkpqryarname.arname, Max(tblfileinspect.caseapr) AS MaxOfcaseapr
FROM tblfileinspect INNER JOIN lkpqryarname ON tblfileinspect.arfirm = lkpqryarname.arid
WHERE...
Forum: Access VBA June 13th, 2008, 07:50 AM
Replies: 3
Views: 1,738
Posted By jeremy1048
i take it there's a reason for simply not hiding...

i take it there's a reason for simply not hiding the controls in question from the user at opening depending on their security
Forum: Access June 3rd, 2008, 10:56 AM
Replies: 4
Views: 969
Posted By jeremy1048
hiya, with the addition of the .value to the...

hiya,

with the addition of the .value to the field names it works beautifully.

Don't know why however without the deambiguity this installation of access 2k has a fit on most things.
Forum: Access June 3rd, 2008, 09:37 AM
Replies: 5
Views: 999
Posted By jeremy1048
Query issue

I've messed around with this for a while and still no joys. I am trying to get access 2000 to bring out the right results

For each employee select the 67th percentile value of ascending ordered...
Forum: Access June 3rd, 2008, 09:16 AM
Replies: 4
Views: 969
Posted By jeremy1048
Parsing query

Hi All,

Got a relatively easy one for all the experienced guys in the house. I've looked 15 pages deep in google searcheson several variations of split / parsing on the net before coming to ask,...
Forum: Access May 8th, 2008, 11:29 AM
Replies: 1
Views: 923
Posted By jeremy1048
Code help - Form misbehaving

Can someone please tell me what is going wrong with this code. It happens periodically. Even though there is a request on another form in the form of

docmd.openform "frmname"...
Forum: Access May 8th, 2008, 11:26 AM
Replies: 4
Views: 948
Posted By jeremy1048
yes its what i was thinking of it was just the...

yes its what i was thinking of it was just the sheer number of groups that was running into.

Currently at over 60000 combinations to code in that way. Access security isn't going to work for this,...
Showing results 1 to 25 of 85

 


All times are GMT -4. The time now is 04:22 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.