Search results

ok with that said, i need to pay more attention to normalizationin the fututre, but can i ask though noted ... and you are right ... for my next project, ill not be making any of these mistakes

can i say ... you are a genius ... a damn genius ... works like a charm ...

This is part of a project to rent party supplies. you start by selecting a customer. I have a list of products thats used to populate the Product ID combo box. The same query is used for each combo box, except that the second combobox will show all except the value from the first box, and the...

i have this form and need to write a query that will get Product name, category, price, quantity in stock from the products table ... Select productname, category, price, quantityinstock from Products where Productid = pid.value im new to written queries ... and this is as far as ive gotten...

i thank you for your response. i wholeheartedly do. i m trying to help a fried do a project. here is the outline. the database is supposed to keep track of extra curricular activities/clubs in a school. there are students and each student has guardians each activity is led by a teacher and an...

Thanks for your feedback. students and teachers cant go together. guardians is not required in the query i wanna create. ill try the new table approach, but is there any way to create a query currently that will show all persons affiliated with the activity

RELATIONSHIPS ACTIVITIES TABLE In the Activities table, Ledby is a teacher,Assistedby is also a teacher. President, VicePresident, Secretary, PRO & Treasurer are all students. How can i create a query to show all participants in an Activity, be they teachers or students ? i wanna show first...

i had discontinued that effort. i had simply resorted to change the layout of my form. the suggestion made by @Pat Hartman had helped. tyvm kind sir

yes i did. works like a charm ... i found a workarounf by changing the forma of my form. i learnt something. thank you

Double ... i have another thats Integer too ... might wanna use the same technique elsewhere

quantity = me.amount.value keeps giving me an errow when amount is empty. is there a way to check if the field is empty and return 0 instead ?

oh snap ... i didnt even see that ... tyvm. two sets of eyes are better than one. im tired too ... thanks a million.

neither of those suggestion worked. instead of -5 im now getting 5 when i reverse the dates, and with the dates reversed when i changed the parameter from "m" to "d" and divided by 30 like you suggested, i still end up with 5

as you can see, the rental date and return date(wich is the expected return date), now when i try to calculate the amount of months that have expried between today, and the expected return date using DateDiff ... retdate = Me.edate.Value aretdate = Date late = DateDiff("m", retdate, aretdate...

ive resolved the issues i was having ... thanks a million guys

cborentals is a combobox populated by a query that spans 3 tables

What im trying to do is get two values, book name and subject from the books table. Id like to learn to correctly use a recordset and use individual values from the recordset.

corrected but now im getting this error and

im appreciate your input, im teaching myself VBA so its a learning process.

and then this