Search results

Good morning DBGuy, thanks for your help. I did get this working, but abandoned the powershell script and tackled both the front and back end backup routines directly through VBA. I ended up using the link you sent previously as a foundation and added some folder detection and creation to match...

I'm not sure this would be possible because I cannot call a script because scripts are blocked by company policy until I change the execution policy in powershell upon calling each instance of powershell. Correct, I am using a powershell script now. I previously used a batch and just called the...

Hi everybody, I created and manage an access database at work, and recently we've upgraded to Windows 10 / Office 365. I have 1 hurdle I am struggling to resolve and was hoping for guidance if anybody has time and would be so kind: The database in question here is a split database. I have a...

Bump bump :o

Yes sir, see attached. Forgive that many features have been removed to maintain confidentiality. I've highlighted the Employee dropdown selector and report buttons in yellow. All you need to do is run press the yellow button and it will generate the report, However, as stated above, take note...

Hi everybody, I have a report I've created which pulls in query data from two separate queries: The report is called: rptMonthlyReport It is bound to the source: qryMonthlyReport This report allows us to select an employee from a dropdown (cboEmployee) and view all active project records for...

Hi everybody, I've created fairly complex database at work here in the US to manage and track a large amount of projects, reports, and data. Initially this was only used at our corporate office, but a need has arisen for users to access this database remotely from Europe. In total, only 15...

The subform source object was a query, and I had it displayed in datasheet view (not form view), so there were no additional controls being used on the subform to use an event to trigger on (like a command button or combo box), only the subform's form events -- which wasn't giving me the result...

Thank you much! I ended up resolving this, but not easily. I did not use the double click event. As you said, it was not specific enough to identify what exact record was selected in the subform. I was using the subform in datasheet mode, so no other controls were used. I actually backtracked...

Sorry, if I could retract reporting the post -- I would. I honestly did take offense as I was asking for guidance in how to set up a subroutine on the double click event of a subform and provided my attempt. The response was a link to "My First VBA" and told me to use design view to change the...

Thank you! Unfortunately, this is exactly where I'm looking for guidance - in how to do exactly this. I tried referencing the field name, ID, as seen below: Private Sub ID_DblClick(Cancel As Integer) DoCmd.OpenForm "frmProjectOnDeck", acNormal, "", "ID =" & [txtRecordSelected], acEdit, acNormal...

Hi everybody, I have a form for users to enter project data into a table. On this form, I also have a subform displaying a list of the users projects. When a user selects a project record from the subform, I'd like the main form to navigate to this record so the user can update their project...

Ok so thank you very much, this works now. Turns out I had the text box control set to rich text and the field in the table set to plain text, so it was turning out as <div>VALUE I AM TYPING</div>. By setting both to plain text, the <div> </div> was removed and now works. Basically just a syntax...

Thank you for the advice! I really appreciate it. Unfortunately, this didn't entirely work. But I believe we are on the right path. I tried what you suggested and the value I type into txtProject shows as <div>VALUETYPED</div>. I set the where condition like you suggested as a string and put...

I have a database I've been designing to track projects. I'm having trouble setting up a DoCmd to open a form to specific records where field values contain alphanumerics. I'll try to keep this simple. I think this is a datatype mismatch issue. Any ideas how to setup a DoCmd to open a form to...

Hello everybody, I was wondering if anybody has or knows of an example database which uses a lookup column to automatically populate a table field. For example, if a database has 2 tables: 1.tblCountry Field: CountryID (Primary Key) (1 to many relationship with CountryID in tblCity) Field...

Thanks for the help! I've got this working well using your advice. I consolidated the tables into 1 which simplified literally everything. This simplified the need for relationships and now there is no more need to use an unbound form to update 2 redundant fields in separate tables. A simple...

Thanks for the advice! I thought about it overnight and based on some of your comments, I'm going to combine the 2 directive tables. The original purpose was so that a user must select a directive from the tblDirectives. I realize now having tblDirectives and tblDirectivesTracker serves no...

Hi guys, thanks for the quick replies. Here's the zip file. Its a work in progress, so forgive me if its still sloppy. I'll read through everybody's responses and post up a reply. Thank you guys for the guidance.

battlefield, all the way. Way better, feels like more of a simulator than an arcade.