Search results for query: *

Hi again, I should have mentioned that when I call up a report with the Access shell hidden I don't get any errors. I just can't do anything from that point forward, and the only way to close the database is with the task manager. Presumably the report is opened inside the shell hiding in the...

Hi Genomon, I haven't tried what you recommended because I'm not sure where I would put it. Should this be included with each form and report or is there a single location which would ba a catch all? I'm hoping to eventually split the data base into front end and back end but it's still not...

ALRIGHT!! PHV You are entitled to 3 free beers on me the next time you're in Bangkok. But for the time being all I can give you is a star. I had to change the cgo to uppercase and the date format to yymm, but otherwise it worked first try. Thanks a lot man! Between you and Golom I've learned...

Hi Genomon, I'm using the one recommended on this site: http://www.mvps.org/access/api/api0019.htm I think it the same mod that everybody's using; it was created by Dev Ashish.

Hi PHV, This is the code that Golom provided. It works fine if the month never changes but when it does the second line sets MaxCgo to Null; then the last line generates the error "invalid use of Null" Dim cgoString As String Dim NewCgo As String Dim MaxCgo As Variant cgoString = "cgo-"...

Hi Golom, I've been out of the loop for a while. I'm trying to learn a new job and Access at the same time, so I've been pretty busy. The database (while it's not quite state-of-the-art) works surprisingly well and is actually producing results. It could be a lot better but it will take time...

Hi randy700 I tried your suggestion but I still got the same error. I came up with my own solution by leaving the query out of the VB code and just calling it. This seems to resolve any syntax problems. I'm still using the same query I created before because it does produce the proper results...

Hello All, I'm currently using the VB mod that hides the Access shell so that the forms appear on screen cleanly without the messy background. I think it looks much more professional and less confusing to users this way. I've got some report previews that are selected from the form, but when...

Sorry Golom, I'm not critisizing your code or Microsoft in general. I'm just really excited about the new things that you've taught me. You took a 9 line algorythm and reduced to 3 lines of code. I like that, and I want to be able to do the same. Some things don't work, but the fun is in...

Hi docjohn52, Golum is using the IIF function because it's more efficient than splitting the code into if-then-else-end if. In a single statement he is doing what would otherwise take 4 lines of code. iif ( condition, value_if_true, value_if_false ) I was wondering what IIF was too so I...

PHV, The table is bound to tblCargo and the text box containing the Cargo code is bound to the field strCargoCode. Cheers!!

Thanks PHV, I tried that but it doesn't fire up the code. I just get a blank form with no Cargo Code. Cheers!!

Hi Golom, I tried your code and it's almost there. It stops at the very last line if I select the new-record button on the bottom of the form. The DMax value is null all the time so it doesn't seem to be picking the maximum record. If I go to the last record manually which is also the maximum...

WOW! Thanks Golom! I'll give this a try tomorrow. Even if it doesn't work this will be an excellent tutorial. Cheers!!

Whooops!!! Sorry about the double post. I didn't show up so I tried again, about 3 times. I hope another one doesn't show up.

Hi All, Thanks Randy700 for the tip, that works great and it's very useful to know. It doesn't seem to work for SQL statements though. I've tried and APPEND, UNION, and INSERT INTO but I still can't get anything into the combo boxes. I'm not sure why I should append because the field already...

Hi All, I've got a relatively simple problem but my VB still isn't up to snuff. I would like to create a Cargo Code using cgo-0708-001 where cgo is just a descriptive string, 0708 is the current month and year, and 001 is incremented with each new record unless the month changes; In which case...

Hi All, Thanks Randy700 for the tip, that works great and it's very useful to know. It doesn't seem to work for SQL statements though. I've tried and APPEND, UNION, and INSERT INTO but I still can't get anything into the combo boxes. I eventually brought the query into vb to see if I could...

Hi Remou, I still haven't been able to crack this one. I've read all about Append Qrery's but all of the examples provided only use one table, which looks simple and strait forward. I'm using 4 tables so that seems to confuse the issue. I know that my code shown above works if I type in a...

Thanks Remou, I've been fairly busy, so I couldn't get back sooner. That last code example worked great. It looks a little funny but it does the job. I had to use a "V" as a down arrow. I'm still having one little problem. The order of the last three cargoes is important but the list places...