Just an update ... the problem hasnt been resolved, but the people who are using it decided they wanted to use a different process anyway, so the form is no longer needed.
Thanks for your help.
Merry Christmas everyone!...
truthlover
Last Activity: Dec 22 '08, 10:52 PM
Joined: Dec 11 '07
Location:
-
I was wrong, I thought it was working, but I'm still having problems. As soon as I can, I'll post the problems I'm still having.
Thanks!...Leave a comment:
-
Never mind, I think I got it working.
Thanks!!...Leave a comment:
-
Hi Chip
I hope you're still around...
I got the first part, but I dont understand what you mean by
Can you explain a little further?
Thanks for your help and your patience!!...Leave a comment:
-
Chip,
I did see this, but it's a little hard for me to decipher (Sorry. I tried to warn you I might need things really spelled out).
I've got some things happening at work that I need to take care of first, but I'm hoping some time next week to tackle this again.
Thanks!...Leave a comment:
-
The best way for me to explain it is to show you the application. (I only included the necessary forms, tables and queries). This will also allow you to see all the corresponding code.
I tried to upload the file, but it said it exceeded the size allowed by the size of the file, not even one MB. (??) So I uploaded it to my site. You can access it here.
Anyway, the file will open to the main form (for purpose of this post)....Leave a comment:
-
I'm putting together a response. Hope to have it up soon. Thanks!...Leave a comment:
-
Hi Chip
Sounds like that could work. Only problem is I'm really not good with VBA and though it seems simple enough, I have no idea where to put the code.
Can you help?
Thanks!Leave a comment:
-
SubForm Problems (Access 2000 format)
I have a problem that's difficult to explain, so please be patient.
The database is in 2000 format, though I'm doing most of the designing in 2007 (saved as 2000 format, of course)
I have a continuous form frmEditConstruc tionLog with an unbound combobox that filters the results to the desired project number. This works fine.
I need to add the option of choosing multiple Crew Members, and this is where... -
Ok, I've tried to make this work, but something still isnt working. My lack of VBA and SQL knowledge leaves me unable to figure out why.
Using the first 7 characters is sufficient, so if someone can tell me how/where to put in the statement that would just pick up the first 7 characters of tbl_SurveyWorkO rder.CADTech I'd be grateful.
Here's my SQL statement:
...Code:SELECT tbl_CrewSchedule.ScheduledDate, [B]tbl_[/]
Leave a comment:
-
Hi Fish,
Thanks! I havent gotten around to trying it, but i'll let you know how it goes.Leave a comment:
-
Hi Fish,
I just looked that up in Access and other tutorials, but I just cant make any sense of their explanation. Sorry, but I really dont know VBA.
How would I code the whole first word and the first character of the second word?
How would I code only displaying the first 7 characters?
Thanks so much! (and thanks for your patience)Leave a comment:
-
Access 2002 - Query question
Is there a way to write a query that will display only the first word and first letter of the second word in a string? If so, how?
If not, is there a way to get it to display only a certain number of characters?
I'm a vba novice. It seems like there should be a way, but all my attempts to search the answers in the help files or this forum have been unsuccessful.
Thanks! -
Yes, I did get help on that. Thanks for replying!...Leave a comment:
-
Not sure if anyone saw this since it was the holiday weekend:...Leave a comment:
-
What am I doing wrong? This is my modification of the code, but I'm getting a "Compile Error: Variable not defined" for both the stDocName and stLinkCriteria.
...Code:Private Sub cmdPrintSelected_Click() stDocName = "rpt_SurveyWorkOrder" stLinkCriteria = "[tbl_SurveyWorkOrder.SurveyWorkOrderID]=" _ & Me![tbl_SurveyWorkOrder.SurveyWorkOrderID] DoCmd.OpenReport stDocName, acPreview,
Leave a comment:
-
It worked great, thanks!!!! You made my week :)...Leave a comment:
-
Thanks Neo
I didnt drop the indents, though. I just copy/pasted and that was the results. I couldnt remember how to code the code for vb instead of text. Guess I should have reinserted the indents to make it easier to read.
Thanks...Leave a comment:
-
Yes, the ProjectID is a string. I didnt change the notes (that referred it to a number) but I had a feeling the fact that it was a string was the problem (I just didnt know how to make the correction).
I'll give it a try and get back to you.
Thanks!...Leave a comment:
-
Ok, I tried doing this. I shortened the code since all I need is the combo box. I also set the source code for the combo box to a query list of the available project numbers (rather than a value list the way the zip file has it set as)
...Code:'CheckFilter produces the new Filter depending on the values currently in cboFindAccountType. Private Sub CheckFilter() Dim strFilter As String, strOldFilter As String strOldFilter =
Leave a comment:
No activity results to display
Leave a comment: