Search results for query: *

Thankyou, for answering my questions so quickly, I thought the same, but sometimes there are those that know everything. I think you deserve a...

Could you do that with something other than the date?? Say a control number. Instead of flipping back through to see the last control number entered.

Which way is better I've been told both ways, but never from someone who does this for a living. For just a simple database should you base your forms from the tables, or create queries and base them from the queries? Does either way help run-time? Just curious...

I have a database set up kind of like northwind to track my office supplies. I have (Form 1) which is a mainform for categories with a subform that lists all the products under that category. I have a add to shopping cart feature also that appends a query into (Form 2) in form two the Mainform...

I have a database set up kind of like northwind to track my office supplies. I have (Form 1) which is a mainform for categories with a subform that lists all the products under that category. I have a add to shopping cart feature also that appends a query into (Form 2) in form two the Mainform...

I have have two tables. Table 1 gives a description of a product. Table 2 has the ordering information on the product. So I have a query that appends fields from table 2 to table 1. That all works fine. But what I want to do is assign a order number to each group. But when I create a table...

VBSlammer, I tried doing what you said last night before I posted this thread I ran into 2 problems. (1)I have it set up where it looks like a catalog you can switch the different categories and there are different products listed. You click on the shopping cart and it adds it to the append...

Hi, I was setting up Supply Ordering database. Basically it's somewhat like Northwind as far as the categories and then the list of products...My question is this.. Is it possible to have a shopping cart feature, after you add everthing to your cart at the bottom of the form it will say...

But won't that date that change as the days change. I need for the date not to change of those 2 to 200 records. If I run the query of the 8-oct-02, I want that date put in the table...And if I go look at it the next day I still want it to say 8-oct-02, not the 9th. But if that is all I have...

Hi, I am have a form based off a query that returns certain results. One of my fields is a date field and anywhere from 2 to 200 results could be returned. It would be tedious to fill in all those dates so what I need is for it to automatically put the current date in that field, but at the...

Mr. Big, I do intend on running it from a macro. This database is to randomly pick X number of records to be audited. Based on what kind of audit they are going to do that's how many records they are going to check. The top module I have works perfectly in randomly picking out records to...

Thanks, guys for your help and suggestions, but the first module actually works quite well. It's the second one that I'm having trouble with. The first module there actually returns random numbers, based off the Top Value selected in the query properties...and that would be fine with me because...

How I would love to give you this program and let you do it?? :) The module you created worked great, but it's not quite what they want now :( They want something a little more extensive and complicated, and I'm just a beginner trying my feet, but I thought you could look at my problem and...

Actually I want a X # of random records to open..We have audits on books and they are random book audits (those are the records I am talking about). Well there are a varying number of books in each file and monthly we have to audit certain files, we don't want to audit all the books in the file...

...Function SetTmpRandNbr() Dim rs As Recordset Dim SQLcmd As String Dim db As Database Set db = CurrentDb() SQLcmd = "SELECT * FROM Random ORDER BY TOID" Set rs = db.OpenRecordset(SQLcmd, dbOpenDynaset) With rs Do Until .EOF .Edit !TmpRandNbr...

...Function SetTmpRandNbr() Dim rs As Recordset Dim SQLcmd As String Dim db As Database Set db = CurrentDb() SQLcmd = "SELECT * FROM Random ORDER BY TOID" Set rs = db.OpenRecordset(SQLcmd, dbOpenDynaset) With rs Do Until .EOF .Edit !TmpRandNbr...

Actually I have several command buttons with the file numbers so when the button is clicked it runs the module to pick the random number I would like for it to ask how many to pick first and then choose random numbers based on the amount picked. I hope what I wrote is understandable, and all...

I have a module running that randomly picks x% and displays it in a query. I know that you can manually go in and change the amount in the query properties, but I'm the creator and I know how to do that, but those that are going to be using the database are unfamilar with how that works. So my...

I have a module running that randomly picks x% and displays it in a query. I know that you can manually go in and change the amount in the query properties, but I'm the creator and I know how to do that, but those that are going to be using the database are unfamilar with how that works. So my...

That worked perfect. Thankyou!