Search results

Ok I asked too soon, I think I've figured it out. For some reason, when you attempt to move records using SQL, it can't detect if a field is a primary key, and thus it tries to copy the primary key into the new table, yielding in a primary key conflict. But if you try to copy records using...

Hey guys, I know its been a few weeks, but I'm getting really close to making this work. I'm having one challenge that I suspect is probably an easy solution, but I'm really not terribly familiar with SQL, I'm still learning. How do you copy records from Table 1 into Table 2, but have the ID...

Genius ideas bastanu, much appreciated input. I had never thought of these approaches. Let me tinker around in the next few days with the flag idea. I also already have the database split, so it wouldn't be too difficult to add a new table to the front end specifically to hold the batch model...

Hello again everybody, I am looking for guidance here on an issue that has been plaguing me for the past few years. Question: How do I duplicate a set of records, then select the newly duplicated records, then update a field on only the newly duplicated records? Context: I have a form called...

Thanks guys. Again, I really appreciate the help. I wish there was some way i could repay you. DBGuy, I did remove the brackets and immediately got a compile error. I added the brackets back in and all functioned properly. Thanks again!

This actually resolved it. I renamed txtCertificateNumber to txtTEST and this actually worked. I changed the name of the textbox back to txtCertificateNumber and updated the code accordingly, and it functions perfectly. I can't claim to know the inner workings of access terribly well, but maybe...

I see your thought process, and I like it. So debug.print me.txtCertificateNumber throw the same error. I assure you, I am spelling it correctly. Maybe renaming the text box might help?

Ok, I feel like this is progress already :) This did not throw an error. This successfully duplicate the record and populated "Test" into the certificate number field of the new record.

Hi DBGuy, I'm actually trying to use Allen Browne's duplicate record script. http://allenbrowne.com/ser-57.html I'm not entirely sure how to answer your question. I am just trying to create a duplicate record command button that copies fields and subtables into the new record. All fields copy...

Interesting though, if I debug.print the field, it works fine...but if I try to push the field to a textbox, I receive an error that the field doesn't exist. Debug.Print [Certificate Number] <-------This successfully prints the certificate number from the record...

Hi, Thanks for your quick reply. But this unfortunately doesn't work. I receive the same error. Thanks for the advice, but this is a DB I inherited. The author didn't exactly use good naming conventions. I'd like to try to update the names, but there so many references. I don't really know how...

Hi everybody, Can anybody suggest how to reference a table column name that has a space in VBA? I'm working on a function to duplicate a selected record and copy the desired data into the new record. All fields work except the fields with spaces in their name. For example, the Certificate...

Thanks for clarifying, DBGuy. I always appreciate your support.

Thank you for the replies everybody. I put aside my work yesterday and dedicated myself fully to troubleshooting this further. I've found the resolution and figured I'd post the solution in case anybody else encounters this. Thank you all for the input and willingness to help. Here is what I've...

I've been struggling for over 1 year to resolve this bug being experienced on 2 of my 7 data input forms for one of my databases at work. If you enter data into any text or combo box on the form, the record locks and a pencil appears in the corner. If you try to leave the form using the close...

So helpful, thank you greatly. Here is the final solution. High level overview: First opens a file selector to allow the user to select a file Second, the filepath of the selected file is stored into variable "RawHyperlink" Next it extracts the drive letter and stores it to variable...

Thanks, DBGuy -- I appreciate the help. It appears I'm in over my head. I'm not sure how to implement this code into my existing file selector code. But I'm making progress. If I can figure this out, I'll post my solution. I got the function to convert the mapped drive letter "R:" into a UNC...

Thank you -- but I don't think this achieves my objective, unless I misunderstood your comment. I have a file dialog module (code listed above) embedded into my access form, called by a command button. I'm looking to modify the VBA code above to instead populate the UNC path into...

Hi everybody, I built and manage a compliance database for my company. Instead of actually attaching PDFs to the records, to keep size down -- I've added a hyperlink text box to hold a hyperlink to the file. I have a command button (cmdFileDialog) which brings a file selector up and lets the...

I actually didn't figure out how to pass powershell commands through VBA. I am happy to share my powershell script (+ the required PS commands to call the script successfully): First, an instance of powershell needs to be opened (or called from VBA): Because of execution policies, the two...