Search results

does anyone know how to prevent users from entering a mdb by hitting alt + f11

How do you remove the toolbar? It doesn't show in my db's but when I put it on another pc, it comes up with the toolbar showing. I tried to set the toolbar control to =1 like you do to remove the menubar, but it didn't work.

I want a cmd button on a form that lets the user "compact and Repair" the database. The menu's have been removed. There is a hidden menu, called "Developer" which is only accessible thru a password protected form, that has the menu option "Compact and Repair Database..." Here's what I have: (in...

On the doubleclick event I have an input box that asks for a password. I want the form to open if inputbox = txtPassword and cancel if it doesn't. I can't seem to "call" the inputbox string. In the Open event looks something similar... if txtpassword.text = inputbox.text then 'do nothing...

I would like to give the user the option of what fields they want on a report. For instance if they wanted to print out a sales report they could choose, before printing, what fields they wanted... DateSold Salesperson SalesRegion ProductSold SoldTo Customer CustomerAddress If they wanted...

I want to add info to a memo field without being able to change info that was already added, and with a date/time stamp. Is that possible?

I want to count the number of orders due for today at the end of a report. The report lists orders due for past future and present dates, but I want to count only the orders due for today. So in the report footer there is a textbox with a control set as...

How do you suppress Microsoft Access error messages? For instance, when user enters date format incorrectly I would like my own msgbox to appear instead of access. But I don't know how to suppress MS A2K's error msg. Any suggestions? Thanks

What I need to do is generate a new record(s) based on selections made by the user that gets calcualted by a query then the appropriate number of records become generated. For instance: Form 1: User chooses if it is a one time purchase order or recurring purchase order. (One time orders - no...

Has anyone every tried the Access 2 VB program, to convert A2K into VB?

How do you suppress this error? It's occuring when a user types something in a combo box - it doesn't appear in the list - the backspace their entry - then try to leave the combo box. I don't want this error to appear. Anyone know how to suppress that?

Hello all, I have a form and on that form there is a combo box that looks up values/records in my form. When the user clicks the pull down button on the combo box and selects a listing the form switches to the correct record. However the problem is... when the user types in a listing that...

Anyone know how to compile an A2K Database into it's own self running program?

Hello all, does anyone know how to create an amortization schedule? Could really use the help. Thanks in advance.

Hello all! Knowing that Access isn't the greatest at handling graphs, I have what I want so far... well mostly. My Problem is that I want the graph to view only the current years data. More specificly, today -364. The date is a field in the query, yet when I try to define the time frame as...

Another question that I have pondered for awhile. I have 6 queries that calculate different values for various results but will use the same date range. Example: Query 1: Counts Customers in date range Query 2: Shows most popular products for date range Query 3: Shows most popular...

Assistance Needed: I have a query that has 3 fields. Date - Standard Date Nosocomial - Checkbox Number - Integer The Date Field's Expression is a Between/And The Nosocomial Expression is =True The Number Expression is where I have the issue. It's not actually a field. I need the...

I'm sure this question has been asked before... but here goes. Is there anyway w/ A2K to develop a .mdb or .mde and place it on another PC that does not have any type of Access... and work?

I'm sure this is posted somewhere else and is quite simple, but I haven't ever had to do it. I could use the boards opinions on this. In the Form Footer of my main form I want to place a cmd that deletes not only the main form record but also the associated subform records that are tied to it...

Hello all, need a little help here. I have a report that contains a subreport. In the subreport is a field that I need to reference on to my main report. Does anyone know how to call a value from a subreport into the main report? Please help!