Search results

Hi All, One of my users recently pointed out that while pasting data into a datasheet form, the validation rules built into the combo dropdown (which grabs valid values from a "CODES" table) do not validate the data being pasted (Tested in Access 2007 and 2010 - same result). Is this...

If I understand what you are saying correctly, this is akin to running it from a remote-desktop session. My experience with remote-desktop is that it is even more bandwidth intensive than my current frontend-backend system. Perhaps it is better still to run it as an intranet website to a...

Hi All, I've been getting the classic "Network Access Interrupted" error on our FE/BE database here on site. The problem is most definitely wifi cutting in and out, as the end users are all using laptops out-doors at varying distance from access points. The real annoyance is that the error...

Hey, sorry for the late reply. Have you made any progress? I've looked at your code, and it doesn't look very different from mine, so perhaps the problem is elsewhere? Are you getting any errors? Try putting a break halfway through the VB compiler and see what the values for space1Between are...

Aloha! Which part of the code are you trying to get running? There are 2 parts; one that passes PK and FK to forms based on the selection in a datasheet subform, and the second which implements show and hide buttons to clean up the form. You can post your code and we'll look at it to see if...

In the Form header of the simplified log form. I'm not positive, but I think it has something to do with reloading the data with the focus inside of the body instead of the header, maybe calling the refresh-script out of order?

Hi Again, I implemented your awesome form-hiding functions, but at some point I decided to make a show/hide button for the header. Since the header won't let me resize it unless I make all of the individual buttons small and moved to the top, I decided it was easier to make the entire thing...

Hi DCrake, Sorry for not getting back sooner- I had a pile of other things to do these past few days. Anyway, I tried your code, but I'm getting compile errors on this line: oSheet.Range("A2").Value = CopyFromRecordset(Rs) the error is: which highlights CopyFromRecordset. I've also...

I just read up on the method, however I am unclear what you have in mind - do you mean to daisy chain two of these together to copy and export everything? I don't see where to specify the starting row to select for copying... Perhaps I misunderstand the documentation. Thanks!

We're using Office 2k7 here, so no problems with Excel/CSV and the 84k records. I have previously exported as much as it would do and then copy and paste the remainder of the records to the bottom they all end up in 1 worksheet just fine. This works, however, I do not expect all of the users to...

I just tested again, exporting to text/csv and got the same error: "You selected more records than can be copied to the clipboard at once Divide the records into two or more groups and then copy / paste [...] the maximum number is approximately 65,000" This is trying to export 84,000 records...

Hi All, I'm managing a very large database with around 15 years of data in it. The primary purpose of the database is to organize and archive scientific data so it can be exported for use in higher-level modeling programs. These programs do not often have the ability to query data directly from...

Hi All, I think that design theory is the best location for this question; I'm managing a very large database with around 15 years of data in it. The primary purpose of the database is to organize and archive scientific data so it can be exported for use in higher-level modeling programs...

Hi vbaInet, sorry for the late response; when I tried to get on over the weekend the website was all fubar for unknown reasons. Anyway, I did get it all tip-top, thanks for asking: just added a goto-first-record to the on-open of the subform and everything's spiffy! Since this new form is so...

Hey that's pretty cool! That trick allows me to lay the form out just like the paper log, and then expand the additional data when needed. Sweet!

Sorry it took me so long to get back, I've had my hands tied with a lot of other projects, so I just finished the changes last night. I needed to remove whitespace from my form names in order to get your script to work (I decided it was better to eliminate the bad-practice rather than define the...

Wow, thanks for putting in the time to make such a nice example! I have my form set up in a way that I think will work, but I'm stumbling over the code: Private Sub Form_Current() If tblLithoID.Value <> "" And IsNull(tblLithoID) = False Then...

Yup: I was simplifying the cryptic names earlier. I think this would work, but wouldn't it would show every single alteration, structure, etc. for an entire hole at once? If so, it is asking for data entry errors. In the split form, if you select one record from the GEOL_MAIN table, it will...

The database is set up to allow a geologist to generalize, and then get progressively more detailed such that whatever level of detail is required can be pulled out of the database and used in GIS / AutoCAD, etc depending on who is doing the analyzing. It works like this: The...

Re: Non-elegant solution to the problem. Yeah, that is effectively what is set up. In my database, HOLE-ID (your HOLE-ID_FK) groups all of the holes together, and MAINID allows detail to be added to depth intervals (your LithoID_FK). The problem I ran into is that I can't use a split form as...