Search results

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

Tried it... It switched to the VB code and said User defined type not defined The heading was highlighted yellow and the Dim db as Database was highlighted blue any ideas? I'd love to be able to do add to a combo box! Any suggestions on what went wrong? Limit to list is set to Yes

No. No records are being added. I'd like to, but don't know how. Private Sub Combo27_NotInList(NewData As String, Response As Integer) MsgBox "Please Select A Patient From The List ", vbOKOnly, "Patient Not Listed" Response = acDataErrContinue End Sub Below is what gives me the error when...

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?

This took the title out: MsgBox "Couldn't Find ", vbOKOnly, "Please Retry" Didn't even think about it... sorry... But now I get the "invalid use of null" any ideas on how to suppress it?

Your first suggestion worked, except the title still says Microsoft Access. Is there anyway around changing the title to something else?

How can I get a user to "add to" the combo box, if the limit to list is set to yes? P.S. Thanks for the other info! Just tried your suggestion.... here's the code and the error Private Sub Combo27_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs...

There are several 3rd party programs out there that claim they can "convert" or "transfer" and an Access DB into a self running program. Has anyone tried these programs before, if so did it work well, was it very involved or just a few clicks. The delimea is should I try it solo or pay...

Limit to list - is set to Yes The error message I receive says Title: Microsoft Access Body: The item entered is not in the list, choose an item in the.... I want to be able to change the "Title" i.e... remove the microsoft access part and put something humerous in. I want to be able to...

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?

raskew, thanks for the code, I'll try it, but do you have any idea why it won't handle more than 36 months? Most situations will call for more than 36 months in my scenario.

I know the formula to find the monthly payment but I don't know the formula to apportion each payment to principal and interest. Can you help with that?

I made a calculator based on an amortization formula that when given: Principal Term Interest Rate gives you your monthly payment. What I need to see is the actual month-to-month depreciating principal - interest earned - interest accrued for the length of the loan based on the term. I...

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

Thanks for all your help. Its working just fine now. Last question on graphs. Is it possible to place benchmark data at the begining of the graph to compare against the db's data?

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...

Pat, I'm sorry, but could you elaborate more on the actual implementation of that

Tried it Newman, didn't work - It asked me twice, so I left out the statement in the Condition/Criteria section and left it as just a field name and changed it's properties to a standard number and it worked. Thank You

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...