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

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

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

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

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

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

My users are complaining about the database taking an extremely long time when doing searches on my form. What they do is click on the field that they want to search and then click on the binoculars (which is just the built in search), and it seems to take forever. It's a network database so...

I'm almost done with my dataentry form, however it looks pretty bad. What I'm trying to do is to size a continous form dynamically. So if on a continous form I have a question and an answer, is there someway to size the detail section depending upon how large the question is? If it's a really...

I've setup a survey database with about 50 questions. I'm curious as to how I can create a form that will work with my database. I have 3 tables, 1 employee table with a primary key as an employee id. 2nd table is just a lookup table with all the questions in it (so just 2 columns), then a...

I have 2 tables that I need to report on, one table has a bunch of student_id's which is my primary key, the second table has 2 fields one is a status, and one is a date. During the lifetime of the database it's going to have 2 status choices for each student, one is a "recieved", and one is a...

I have 2 tables that I need to report on, one table has a bunch of student_id's which is my primary key, the second table has 2 fields one is a status, and one is a date. During the lifetime of the database it's going to have 2 status choices for each student, one is a "recieved", and one is a...

I've read that if you use grouping within DAP's then you automatically create a read only page. I know that with access there's almost always a work around for everything. If there is some kind of vbscript I could use I would greatly appreciate it. Thanks so much. -db

I have a form that has a query subform inside of it. Most of the people who will be using this database won't know how to right click on the column headers and choose to sort accending or whatever. So my goal is to have a command button under the query that says something like "Sort by...

I'm referencing a value in a combo box on an open form for a text box in my report. Instead of getting the value I get the location on the list. For instance My combo box could have red, green, and blue. If I highlight Blue and run my report (I have a text box that says...

I know I need a form to create some criteria for inputting date ranges, ID's, ext. (I'll try looking through previous topics). However I'm having trouble finding a simple way of reporting on this criteria. I have a simple survey database in which users in *ONE* record will have to answer...