Search results

I have a database that I would like to offer to someone however I need to let them use it for 30 days before they decide to buy it. I would like to offer this trial to people so that at the end of 30 days it will no longer work. Any ideas on what I can try? Anyone ever tried to do something...

You can do something like this.... Private Sub List0_LostFocus() '************************************************* '* Procedure: List0_LostFocus() '* Parameters: none '* Purpose: Add items selected to an append query '************************************************* Dim varItm as Variant...

I need to send a data type "long" to another form, and want to make sure that I conserve memory. Does it really make a big difference If I send the value to a variable within the code, or to a text box? Won't a text box take up just as much memory as a form level variable? -db

Pat, Thanks for your response. You have always been a great help with all of my questions. I think you are right I would want to go with Tables, however if I just have two possible choices like "Male";"Female" this would probably work with a value list, correct? I am going to continue using...

Anytime in the past when I had a option in the database about sex of a person, (like Female or Male), I would create a table called "SEX" then put male or female in as a foreign key to the main table. Is this better then just using the option of a value list and a text box within the same...

Edit the button which moves to the next post and put something like ... If IsNull(Insert Name Here) then Msgbox "You forgot to fill in all the fields" Else [Insert code here] End If

Sure this can be done. Just create a button or something that you want to create an event on. Right click on it and go to "Build Event" and choose Code Builder. Next just put in the following code... DoCmd.SendObject(acSendForm, "MY_FORM_NAME", acFormatRTF, "RECIPIANT", , , "MY SUBJECT"...

The database currently resides on my PC. I would send it to you so you could see it but it has confidential information within. -db

If you are using Access 2000 or XP you can use conditional formatting. You can find it by opening up the form in design mode, highlighting what you want to change and then go up to Format on your menu bar and click conditional formatting.

Wayne, Thanks for the response. The database window opens however when you goto design view and view the code, it says "A Network Error Has Occured" and it opens up a blank module which has no code. When I goto Extract the forms, reports, or modules (Anything with code behind them), it...

Good idea, but unfortunetly that is one of 50 fixes I have tried. My database opens fine, but anytime it runs any code, it fails because it does not know where it is.

I just worked for the past 48 hours on one copy of the database. Stupid...Yes of course it was. I went through and commented all of my VBA, and was thinking wow this is really good. I had well over 100 pages of code, not one line was not commented. Then I went and imported everything into...

Okay thanks to a couple other posts I was finally able to figure out what I was doing wrong. I had to use the tab control change property. Private Sub TabCtl0_Change()

Let me restate my problem. What I really want to do is create a tab control on top of a tab control. Is this possible?

I am trying to insert a sub form over a tab control and everytime I do it does not attach to a particular tab. The problem with this is as I go through the different tabs I can see my sub form on every tab instead of just being on one form. Any ideas? thanks

I want to make sure that I add the correct DAO object because I have 3 choices. Also this database will be used by 5-10 people using Windows 95 and Windows 2000. Can you tell me if after adding a reference they will not have problems? Thanks -db

I would like to do a recordset, however everytime I use the variable database it says user defined type. I am using this within a form, do I have to create a module to use this within Access 2000? The following code is how I have it set up.... Dim objDB as Database Dim objRS as Recordset Set...

Of course right after I posted my question, I figured it out. All I had to do is append to the table and over write the autonumber with the appropriate number I want to use. This worked first try, but Its good to know if I don't have any records in my table and compact twice I can re-start the...

Anyone happen to know if there is absolutely anyway to re-use an autonumber that use to be in place, but the record got deleted? I know all about how if you delete all the records it just keeps going and never re-uses the old number. But is there a way to force it to do this? Thanks. -db

Going on the idea, that if I set a variable to something while using the form, the next person to use the form will not have the same variable value as me, since it saves the value in my local memory. I would like to know if everytime someone uses a form, I set a value in an unbound text box to...