Search results

I found this on http://www.tek-tips.com/faqs.cfm?fid=2562 and it works great to hiding everything, however it doesn't let me go back to design mode with all the menu options but throws an error #2046- "The command or action 'DesignView' isn't available now" when I run below code. Private Sub...

Thank you Catalina. I will try it out today.

I like the option two better because I know it's only very few culprits, I just need to fish them out. They only have three forms to work with, but for some reason they end up selecting wrong one and start entering info, then realize that it is a wrong form. I have a "Clear" button which clears...

I disabled the right click options and close button on the form with property setup so user doesn't close the form without completing it. Then I ran into an issue where they were just simply clicking "X" on the top of the application to close the form and relaunch the app. This was creating some...

Hi everyone, This is a great forum and community here is great. Always responds to all questions. Much much appreciated all the help I have received from everyone so far. Still a beginner here on DB and VBA. I want to build a DB that can track the cash flow of a small cash register. Just...

Solved. just had to assign the variable as date and compare it with the clock. Private Sub Form_Timer() Dim ReportTime As Date Me.TxtTimer.Requery ReportTime = Me.TxtTimer If ReportTime = "17:19:00" Then Pending_Report End If End Sub Thank you for all the help.

I tried few ways to achieve this but failing so far. I created a form name FrmTimer which runs on the background (hidden). It has a textbox name TxtTimer (digital clock). Time Interval is set to 1000 and On Timer event I have following code. Private Sub Form_Timer() Me.TxtTimer.Requery If...

Hi everyone, I have a DB which runs 24/7. I would like to automate certain reports to be exported(Excel) at certain time with data and time included in report name. Is there a way to achive this from access itself without Task Scheduler? I don't have admin access so I can't schedule a task to...

In my Navigation form, I have few tabs. If user is using of the tab to enter data, and in the process(in case incorrect tab select) if user clicks on the other tab, it will create a record on the table. I would like to eliminate that since it is creating false records and I have to clean it...

Hi guys, I have finally created my first DB using everyone's help in this forum(Thanks all) and from prof. Google. DB will be multi user and used 24 hrs. It has front end and back end. Everything seems to be working great so far. Now I want to setup compact and repair function on daily basis...

Up until few minutes ago, reports were opening just fine (not the full screen but appropriate size). Now it opens up in small bar size window. How can i fix this. (Unfortunately I am unable to post picture. All the options are disabled.)

Hello, Trying to figure this out for last few hours. I am new and self taught DB. Here is the problem. DB is for Issue/Return items. Sometimes items are checkout on day1 and cheked in on day2. When an item is issued, it generates and unique Tras No, which shows as pending in a separate form...

I have two identical tables, TblReturn & TblReturnVoids. On the form there is a Void button. I would like to move selected recorded from tableTblReturn to TblReturnVoids when user clicks on Void button. I know, Void (YES/NO) is much better option but compliance wants voided records in a...

On my report, I have two txtboxes which are not part of the query (control source are the expression which pulls record from other fields). Now I want to add txtbox2 based on the value of txtbox1 for all the records. i tried below expression but it is asking for parameters since textboxes are...

That worked like a charm. Thank you:)

I have a report which has employee names, Status (check in/out) and the amount. When report is generated, it shows all day's activity of employee checking in/out items. I manage to format check in & out to two different colors, but I would like to add additional color coding for employees who...

Steve, Thank you for the setting up print function for me. That was very helpful. After spending crazy hours to get the form to go to new record, i just figured it out. I set the Modal property from No to YES (keeps focus on the window until closed) and then just applied the macros without...

Here is the test database. I recreated the error I am receiving. Also the printing issue. Thank you

Facing another issue now. When I have form part of the Navigation form tab. 1. It prints all the records instead of just selected one 2. Throws an error for RecordsGoToNew I updated Macro little bit but results are same.

I have one query to generate different report by passing different criteria.