Search results

What pbaldy said. Also, I wouldn't want to use names like Value or Number as my query output field names, as such names have/might have a specific meaning to MS Access.

Remember, however, using Format(Date(),"ww), same week number is assigned Sunday through Saturday. So, if 1/1/year is Saturday then Format(1/1/year, "ww") = 1, but Format(2/1/year,"ww") = 2. If your x-ref table specifies week number in a different way you'll probably need a different approach...

Make sure the two fields you use to join both tables together are of the same data type.

One way would be to manually replace 27 with 21 in your table but then you'd probably be settled just jotting it down on a piece of paper. Assuming you track orders in your database you could have it done automatically after each new order details are filled (using an update query). Another...

I've tried setting SOMETHING up in the Switchboard Open event, close, but no cigar. I'm no expert, however. AutoExec macro seems to work fine though - I created a function in a module that opens the switchboard but when on error it opens a form to locate a BackEnd db and update links. So far...

So I guess I should avoid switchboard at startup then? Maybe run an AutoExec macro which will open the one form used to repair a broken BackEnd db link if DoCmd.OpenForm("Switchboard") generates an error?

Fair enough. I've tried the switchboard form on open with little success. How and where could I do it? thanks.

Hi I have a database split FE/BE At startup switchboard pops up, however when back end database is no longer where it should be it only returns a message "could not find file ....". I have a form for user to select where BE dbase is located which will then automatically refresh links to all...

Perhaps you could use the DateDiff function. The one record in Rates table with lowest non-negative DateDiff("d", Rates.EffectiveDate, SelectedDates.Date) is what you're probably looking for, assuming you don't want to return rates with effective date past selected date. If two or more...

SELECT Tabla1.Id, Tabla1.Letra, Tabla2.ID_tabla1, Tabla2.Id_num, Tabla2.Cod FROM Tabla1 INNER JOIN Tabla2 ON Tabla1.Id = Tabla2.ID_tabla1 WHERE Tabla2.ID_tabla1 IN (SELECT ID_tabla1 FROM Tabla2 WHERE Cod = 2004)

The way you explain it it's rather impossible to understand what is it you're trying to achieve. Post your table details with some records, how these tables are related, then (based on those records) an exact output you want your query to create. With what you've provided so far I doubt anyone...

Use an UNION query, something like SELECT TDate, Sum(L) As Longs, Sum(S) As Shorts, Sum(A) As Amount FROM ( SELECT TDate, Count(*) As L, 0 As S, Sum(Amount) As A FROM tblTrade WHERE Type = "L" GROUP BY TDate UNION ALL SELECT TDate, 0 As L, Count(*) As S, Sum(Amount) As A FROM tblTrade WHERE...

I believe the error may be due to incorrect quotation marks. Try " instead of ”

I prefer to save an excel sheet as text, link the text file it to ms access then append to a table.

Well, I eventually came around this problem using the Nz function. It seems to work fine with this line in the OnChange event of the combo box Me.ComboBox = Nz(Me.ComboBox, "") Now users are unable to type in or delete anything, all they can do is select from the list.

Hi! I'm trying to handle an error when the user deletes the value selected in combo box which eventually leads to the "You tried to assign the Null value to a variable that is not a Variant data type" error message. I haven't even thought about it before receiving user feedback on this thing...

I knew it had to be simple, but this is as simple as it gets. Thanks Rich!

Hi! I have a form which displays company data. I have a few continuous subforms within a tab control. One of them displays employees working for that company. Now in the employee table I have a EndDate field. This field represents whether the employee is active (Null value) or non-active (date...

what about BETWEEN 5 AND 9?

To count the number of times "Exp" appears as standalone value: SELECT COUNT(ProductName) As Count FROM YourTable WHERE ProductName = "Exp" "Exp" anywhere in a string: SELECT COUNT(ProductName) As Count FROM YourTable WHERE ProductName Like "*" & "Exp" & "*" Count the number of times any...