Search results

Good evening, everyone! My company has disabled vba for our access database due to security reasons so I've only been able to use embedded macro actions for a tracking database I've created recently to better organize our electronic records. I'm trying to create a search form in which I could...

Thank you so much, boblarson! Sorry for the delay in response - got too caught with work. I was really hoping there was a way. Thank you again!!!

Hi...we've put together a database to annotate our daily workload. Unfortunately, our group policy since we migrated into Office 2010 has changed to where we can no longer use VBA scripting. The database has stopped working but managed to still run its basic functions using macro except for...

Thank you gwunta. I will surely try that. I'm somewhat rusty with running SQL in access so I'm hoping I'll be able to do this. I just thought this was possible from the form itself. @booty thanks for pointing out to use Date() instead. I will change it.

I'm sure this probably has a simple solution but somehow I'm having some issues trying to figure out how to prevent a form to insert a record once it has been updated that day; yet still allow edit For example: If a record has been entered for today and someone tried to add a new one later...

Sorry for the late response. I will try that. Thank you so very much!

Hello Everyone, Just wondering if anyone might be able to help me with my dilemma? I'm trying to put a timestamp on my main form to record the date and time a user created a record. I only have one table consisting all of the data to include the date and user. The mainform has two tab...

Thank you so very much, Paul and Linq! I can't believe I never thought of that in the beginning...I guess I wanted to find out more on how to do it! Thank you again!!! :)

I have a tabbed continuous form from which I double-click on a record and displays all the details of the record in a separate form. When I close the form, I can go back as far as opening up the continuous form but focus is set on the first record with the code below: Private Sub Form_Close()...

I'll try that. Thank you so much. Now, how would do this using the split function?

I was hoping if anyone could help extract strings from a textfield. In a textfield(textfield1) I would like to be able to extract words separated by delimiters and put in a separate textfield (textfield2) without the delimiter. For example: textfield1.value = "Apple, Orange, Tomatoes" After...

I was wondering if anyone can help me with my dilemma. I have this report which I'd like for it to call a function every time it loads (see codes below): Private Sub Report_Load() lblCC.Caption = getSignBlock() End Sub This function is from a module I created (which I'm not even sure if I...

Hmm?...I'm not sure...it's giving me an error saying that the table is currently being using by another program or user even though the form is already closed and the only form that's open is the filter form...I'll have to check that out again...

I think I figured it out but thank you so much for the response. The way it's supposed to work is that when I open the dept_form and click on a command button to open a tabular form with a list of employees not assign to any department, when checkbox is checked it would assign the particular...

I was wondering if anyone could help me with a problem I'm having with a form... I have 2 tables, one called 'dept' and the other called 'employee.' These tables have a one-to-many relationship; basically, one department to many employees. Instead of using a combo box, how do I assign an...

I apologize for that, Paul. I'm new with forums and I think I responded to it. I'm still kinda pinging on how it works. I do appreciate your assistance and thank you. I've been really rusty with coding and I'm still trying to recall how certain functions work in access. I didn't mean to...

I am just trying to improve a particular tracking system in our office on how we handle requests for work. The current system is being done manually by logging the data into a logbook. I am trying to generate a control number that would autopopulate a given textbox in a form in MS Access. The...

For example: - the first request for the day would be "KEZ6313001AA" ...the 2nd would be "KEZ6313002AA" ...the 3rd "KEZ6313003AA" - for the next day, it would be "KEZ6314001AA" ..."KEZ6314002AA" ...& so forth - now the 'KEZ' is a constant string so it would always begin with "KEZ"; however...