Search results

Usually I find linked tables give way poorer performance. I usually find I can quicken things up if I do most of the work in a passthrough query, and do the final filtering in Access on a query based off the passthrough. Might not work in your scenario, but thought it worth a mention.

CREATE FUNCTION dbo.fnSplit( @sInputList VARCHAR(8000) -- List of delimited items , @sDelimiter VARCHAR(8000) = ',' -- delimiter that separates items ) RETURNS @List TABLE (item VARCHAR(8000)) BEGIN DECLARE @sItem VARCHAR(8000) WHILE CHARINDEX(@sDelimiter,@sInputList,0) <> 0 BEGIN...

Why can't you just NOT add them to that IF statement? It appears it is only checking to see if the required fields are NULL, and if any of them are, gives that error message, otherwise opens the report.

Select MAX(InvNo) from Invoices, but I bet that is to simple for your needs. What is the format of your invoice number?

Funderburgh: Sounds like (and I may be wrong) you are confusing a Linked table with a Related table. Linked tables mean the physical data resides somewhere other than the current access MDB file you are in. Related tables means they are joined by some data relationship somehow. So what you are...

Are using linked tables or a passthough query against oracle?

Try this link for a little explaination

Try this thread

What does the PK look like (I am assuming it is not literally "PK", that would be to simple)? But on the outside chance it is actually "PK" you can do a RIGHT([A],LEN([A])-2)

I think how you approach this depends more on how you want to "see" if someone already exist. Are you planning on a straight comparison, example first name = first name and last name = last name? Or are you going to get more complicated than that? You could use a simple vMyLong =...

You can either use VBA, or default values using dlookup to get the initial values. To update, you either need to create an append and or update query that reads the values from the form, or handle it in VBA. basically

Does this table (fees) have 500 rows in it? Or does it just have the 10 you entered?

In a query it would be basically ColumnName: Quartile("datatableString","dataString",somenumber) Of course column names can be used instead of literals such as ColumnName: Quartile([datatablecolumn],[datastringcolumn],[somenumbercolumn])

Sounds like the column is not null, nor is it zero. What is the datatype of that column?

Consider either something like a combobox to select the price boundry. Or if you want to base it off an entered quantity, how about qtylow and qtyhigh fields instead? Then a simple between or >= and <=. Of course if you qtys are tied to a specific product, you could always get the max where the...

maybe you should set the default (at the table level) on that column to zero. I usually do that on numeric columns. But it should still show them using that any of that code given you. Strange, really, strange. Let me ask this, when you said you removed the zeros, what did you remove them too...

pbaldy is right. I usually default those controls to hidden until the button is clicked, them show them using the clicked event of the button and VBA.

Have you tried this? SELECT Fees.FeeID, Fees.StudentID, Fees.Fees, Fees.DateEntered, Fees.CollectedBy FROM Fees ORDER BY NZ(Fees.Fees,0) ASC; Which should return the same number rows as this returns as a count: SELECT COUNT(Fees.FeeID) FROM Fees Of course have the column and table name the...

Well you could go for the most detail during data entry, then use a cross ref. table to convert one or more to what your clients want. As one way

Since you have a country table, I assume it is a combobox to choose the country from. I would use the Click event on that combobox to populate the others. How you populate them depends on the type of control they are.