Search results

Sorry, my bad. I had the wrong names in the code. Thank you so much - the code works great. However, I'm interested for accuracy reasons and more inclined to have a table. Obviously as you stated in the code I'll have to use the different if statement in the VB code. I assume looking at your...

I got problems. I have put the code into the module caled 'Workdays', but am right to assume that because I have no holiday table that I can take some code out of it? Thus it looks like this: Public Function PlusWorkdays(dteStart As Date, intNumDays As Long) As Date PlusWorkdays = dteStart Do...

So I put that into a module, but how would I incorporate the code in the form to use this new module code? Obviously the below will need to be modified. (Sorry, just new to this VB stuff).:( If Me.Tick7Day Then Me.Text7Day = Date() Else Me.Text7Day = "" End If

Current code: If Me.Tick7Day Then Me.Text7Day = Date() Else Me.Text7Day = "" End If Okay, I have a check box and a text box on my form, but I need some assistance with complex VB code to make something work. At the moment if the check box is TRUE then the current date...

Sorry another question of similar nature I have another check box called 'Tick7Day' and a textbox called 'Text7Day'. I want the check box, when ticked, to insert the current date into the check box. Not sure of the code, and now sure of whether to use VB or conditon formatting tool for this.

Thanks to this forum I now use the below code in one of my forms in the database: Private Sub TickRelease_AfterUpdate() If Me.TickRelease = True Then Me.LabelRelease.ForeColor = RGB(69, 139, 0) Me.LabelRelease.Caption = "Release" Else Me.LabelRelease.ForeColor =...

That code if (obviously adapted for my database) works perfectly to change the colour - thank you! However, I would like it to display alternative text. What would be the VB code for that? BoxTicked = 'Release' text to be displayed in labal Box not ticked = 'No Release' text to be displayed...

I have a form with various fields, tab control etc on it. I also have many tick boxes on it, and many of them work great. However, I have two tick boxes that I want to reduce to just one. For example the current database has: [ ] Can be released? [ ] Can not be released? I see it as a great...

Not sure if this falls into the reports, query or macro part of the forum so I'll post this simple question here. I have a fully working database that records car information. More or less every day we print of various letters for that vehicle. I have been tasked with making a database look...

Hello I have a database (Access 2007) that has two tables, reports, queries and so far all seems to be working and going well. Quite impressed with it to be honest for my lack of skills. However, I've run into a bit of trouble and need assistance getting a combo box to work with another combo...

Hello I have a database (Access 2007) that has two tables, reports, queries and so far all seems to be working and going well. Quite impressed with it to be honest for my lack of skills. However, I've run into a bit of trouble and need assistance getting a combo box to work with another combo...