Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
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 14 of 14
Search took 0.02 seconds.
Search: Posts Made By: ecampos
Forum: Access VBA June 23rd, 2006, 12:55 PM
Replies: 6
Views: 11,265
Posted By ecampos
Here's how I've solved it: in the Update...

Here's how I've solved it:

in the Update query in design view:
select your field and your table.
In the "Update to:" field:
DLookUp("[YOURFILED]";"YOURtableNAME";"[ID] = " & [ID]-1)
"Criteria"...
Forum: Access VBA February 21st, 2006, 10:29 PM
Replies: 6
Views: 11,265
Posted By ecampos
I figured out a way with an update query, a...

I figured out a way with an update query, a dlookup statement in the "update to" field and an "is null" statement in the criteria field.....

Thanks for the help
Forum: Access VBA February 19th, 2006, 09:08 PM
Replies: 2
Views: 888
Posted By ecampos
Preview the report, then: file > export > save as...

Preview the report, then: file > export > save as type > rich text (*.rtf), save it to your favorite location
then open this saved file with MS word...
it saves most of the formatting also....
Forum: Access VBA February 19th, 2006, 01:07 PM
Replies: 6
Views: 11,265
Posted By ecampos
Thank you for your suggestion, the thing about...

Thank you for your suggestion, the thing about transfer it to excel is that the data importing is a task to be performed everyday by a person who is not very computer savy. I want to make the process...
Forum: Access VBA February 19th, 2006, 09:27 AM
Replies: 6
Views: 11,265
Posted By ecampos
Copy previous field record if next field is null

I have imported records into a table and some of the records have empty fields. All of the blank fields (number and name) belong to the previous record. For example:

Number Name ReportTo ...
Forum: Access August 18th, 2005, 08:08 AM
Replies: 16
Views: 3,695
Posted By ecampos
Yes, the form is bound to the table where the...

Yes, the form is bound to the table where the numbers are being recorded, and there are no subforms.
I know you are a busy person, but if you don't mind the intrusion I can send you the database for...
Forum: Access August 17th, 2005, 02:18 PM
Replies: 16
Views: 3,695
Posted By ecampos
I did, and after each entry a message is...

I did, and after each entry a message is displayed "tblInYArd.EmpNum the field cannot contain a null value because of the requeired property is set to true. enter a value in this field." I dismiss...
Forum: Access August 17th, 2005, 09:06 AM
Replies: 16
Views: 3,695
Posted By ecampos
I changed the default values in both the table...

I changed the default values in both the table and the form as follows:
in = true, and out = false. The first and second new records work as expected, from then on, all records are marked "out".
Forum: Access August 16th, 2005, 03:08 PM
Replies: 16
Views: 3,695
Posted By ecampos
When I place a break in the code and hover the...

When I place a break in the code and hover the mouse over the lkup, it shows the right number typed in the text box but also shows a -1 besides it, the immediate window also shows the number and -1...
Forum: Access August 16th, 2005, 02:13 PM
Replies: 16
Views: 3,695
Posted By ecampos
Well, when the table is empty then the "IsNull"...

Well, when the table is empty then the "IsNull" is true and the chkIn value is set to true in the first part of the If statement. The default values for both chk boxes are blank, I did not select...
Forum: Access August 16th, 2005, 12:28 PM
Replies: 16
Views: 3,695
Posted By ecampos
Thanks again. I pasted your code directly in the...

Thanks again. I pasted your code directly in the form under the afterupdate section, and started with an empty table. I'm getting the same end result, all inputs are marked as "in" as if it is...
Forum: Access August 16th, 2005, 09:13 AM
Replies: 16
Views: 3,695
Posted By ecampos
Thanks for the advice. The last end if is at the...

Thanks for the advice. The last end if is at the very end of the code below the error handler statemnet, the code compiles without any error "else without end if", I must not have pasted it. The...
Forum: Access VBA August 15th, 2005, 08:09 PM
Replies: 1
Views: 5,079
Posted By ecampos
Dlookup with If ..Then ..Else and Chkboxes

I'm trying to get the most recent time record from a table. I found Allen Browne's Elookup() function at http://allenbrowne.com/ser-42.html and it works (it adds a fourth "sort" argument to the...
Forum: Access August 15th, 2005, 07:13 PM
Replies: 16
Views: 3,695
Posted By ecampos
Dlookup with If ..Then ..Else and Chkboxes

I'm trying to get the most recent time record from a table. I found Allen Browne's Elookup() function at http://allenbrowne.com/ser-42.html and it works (it adds a fourth "sort" argument to the...
Showing results 1 to 14 of 14

 


All times are GMT -4. The time now is 10:24 AM.


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