Search results

Hi Folks, I am creating a database for a friend, the database has four main tables and and one intermediary table ( to remove any many to many relationships) I have popluated the DB with some test data manually and my queries thus far appear to be working correctly. What I need to know now is...

as I said above, I changed my logic and run Sunday as a separate query and added it during the final calculation: ' if less than 47.5 hours are worked, then no overtime If Me.txtResult <= 47.5 Then Me.txtExtra1.Value = 0 Me.txtExtra2.Value = 0 End If...

Have you looked at your query in SQL View? You are basing your form on a query yes? Create a query where your criteria for the date is similar to the following: SELECT sum(Cost) FROM tdatInventoryRec WHERE recdate>=WeekStart AND recdate<=WeekEnd That is to say, whatever your WeekStart...

After walking away from the problem for a day or two, I realised that I can get the total hours for Monday thru to Saturday using existing my sum query (instead of Monday thru to Sunday), and fetch back the Sunday seperately, then add Sunday on at the end. Silly me ;) Sometimes one can stare at...

I forgot to add that my application uses a calendar object to select the startDate. I use an onclick event to set and calculate the endDate for the week. Basically the endDate is the startDate plus 6 days, so it would be the sixth day that is the Sunday. Also, I am now thinking this may be more...

Hi there, thanks for the code, but could you please explain it? what is vbSunday? Can this be used for any day of the week vbMonday etc? and is weekday an internal function? Please excuse my ignorance, I would just like to understand the code rather than just paste it in willy nilly so to...

I would have thort that more than a little complex for mere homework wouldn't you? I've just completed a computer studies degree and have not covered this topic, still not sure if I understand it completely either ;)

Hello peeps, I have been working on a hours checking application, in which the user can enter their worked hours for the week and the application calculates how many hours at normal rate , time and half rate or double time rate have been worked for the week. All has been going swimmingly, with...

I suppose you could have a yes/no field, as a boolean and use it as a flag. That is to say, test if it is either yes or no and perform the desired operation upon running a query against the value. create a Form based on a query (which in turn is based on the table with the yes/no field)...

3NF should suffice in most cases, but then again that is only my opinion. As for your redundant data (repeating info) think of functional dependency. Does it depend on the entity? What I mean is, does all the stuff about the policy depend on the customer? Or does a lot of depend just on policy...

you are looking for a multiple tabled, relational database. You need a customer table with customerID, name etc all the usual customer information, 16 digit card number? set the id (primary key) to a 16 digit number (5555194600000001) and then set it to autonumber. alloting values and...

me too, I heartily agree

have you checked that the data required by the original query is not corrupted? if the query fails, it could be a cascading result. double check that the query you are calling is working correctly by running the query from the query window.

It's most probably a typo, check the doCmd code behind your button, or even try this code (obviously replacing the names for your forms) Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmThaYouWantToOpen" DoCmd.OpenForm stDocName, , , stLinkCriteria...

Take a look at this link, it helped me immensely. All I had to do was replace the variable names for it to work for me. My form only had two fields which were based on a query, I added an extra text files and command button, pasted the code and it woked like a charm...

and what criteria you are using for the query, wihtout this, no one can help you.

cool cheers

As the person above states, you ned two tables one for the customer and one for the sales, you need a primary key field called something like customeID (or something similar, it doesn't matter what it's called, it just hasd to be unique) for the sustomer table, set the primary key field to...

silly me, all I had to do is use the format option in design view doh:D

Hi there, Thanks for the prompt reply, is it possible to have the Date without the hours, minutes and seconds? Although your suggestion does help immensly thank you