Recent content by benc

Hi on one form i have lots reasons to call the same bit code i.e. from different buttons or key presses. Rather than write the code over and over again i would like to know how to write the code once and then call it when needed. Thanks in advance

Hi Im trying to create a membership directory for a club but people pay a monthly fee can anyone offer some advice or has an example that i can work from to create this. I need to to just keep there name and address etc and their payment history and then every month print a list of those who...

On my form i have created a button from the wizard and selected to email the report as an attatchment. when pressed the user is asked what format it should be sent in. Is there anyway we can specify in the code what format we want instead of leaving it up to the user. Private Sub...

I have used the same criteria and works well. On my form i have just created a button from the wizard and selected to email the report as an attatchment. when pressed the user is asked what format it should be sent in. Is there anyway we can specify in the code what format we want instead of...

I found a further problem that when i try to edit the results of the query in datasheet view they are un editiable. Am i not allowed to edit the results or is there something wrong

That works. The only problem with switching the visibility on and off is that it leaves gaps in the form layout which personally i think looks messy. But Thank you for all your help

I am trying to enable according to a variable. I have disabled a button by default and want to on form open enable it a criteria is met. I have written the following: Private Sub Form_Open(Cancel As Integer) If gvusertype = admin Then Me.adminmenu.Enabled End If End Sub However i...

Thanks that worked, and sorry about your name.

I have a problem with public variables, I tried exactly what Pat Hardman wrote in Public Variables as Parameters and found that my returnfunction would always be a null value even though my GV did have a value. here is my code: MODULE: Option Compare Database Dim gvactype As String Public...

I have to check to see if a value exists in a table. I wondered if a Dlookup would work but i would need it to return a true of false value. Can anyone advise me on the code. Thanks

I am trying to design a db that handles a daily stock summary. Tables: tblPurchases tblSales tblStockSummary tblStocksummary: Date | Product Name | Start Stock | Tot Purchased | Tot Sold | End Stock I am trying to figure out whats the best way round this. 1st Idea. to create some sort of...

i thought so, so why doesnt my returnfunction take across the gv or am i going about calling them into the wuery all wrong with a return function

I have transfered the code across the a class module but still the returnfunction has no values. I have attatched my db so you may have a look. frmsearch is the form that loads the values into the variables. It opens frmpartslistresults which is based on query, QryPartslist. Thanks for having a...

I rearranged the code and it now loads the forms. When it produces the msgbox of the gv it returns the correct values however when i call the returnfunction so i can use the variables in the queries there are no values. is there something wrong with my module. Option Compare Database Dim...

I have created a Global Variable and function as below: Option Compare Database Dim gvactype As String Dim gvchecktype As String Public Function Returngvactype() As String Returngvactype = gvactype End Function Public Function Returngvactype() As String Returngvchecktype =...