Search results

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 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...

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 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 =...

Global Vairables Could someone just remind me how global variables work. i have set a gv in my module :- dim actype as string how do i set the value from from a form e.g. actype = me.frmactype and how would i call this into a query criteria e.g. [actype] Thanks in advance

I have a current stock table that is updated accordingly to either a purchase or sale. Is there anyway that this can be shown on a form in a bar chart that either went up or down according to the amount of stock. There is a maximum amount of stock that can be held. Any ideas??

I wondered if it was possible that if i have a field box on a form and there was too much field to see in the box that the text could automatically scroll from right to left. Anybody got any ideas or is this a definate no no! Thanks

Hi everyone I have this huge query that i need to run below is the SQL code:- aaah SELECT tblOpRotation.ArrDate AS Dte, Format(tblOpRotation.ArrATA,"hh:nn") AS ATA, tblOpRotation.TailNo AS TailNum, tblOpRotation.ArrAirportName AS AirportDscr, tblOpRotation.ArrFlightNo AS CallSign...

I have create a query that get its criteria froma form entry with the code below. [forms]![search bookings]![customername] However this does not allow the use of wildwards when typed in the form as it shows no records. e.g. *Acme* IS there anyway that my code can be change of the use of a...

I would like to set the form to open on a blank form as though to enter a new record but for the user to use the scroll buttons to search past records. I have tried setting the Data Entry property to yes but i cannot scroll through past records. Can any one help? Thanks

How can i set the criteria to of a query to be the value of a global variable i have created. THanks

Hi I would like a query where i would like to see all the records within a certain date range and the do a count on a field. However when i run this query it shows me all the records on each day if there was a record for that day. It would then count how many records were on that day. however i...

i have a gv set called vlevel i would like to set an on open code that if vlevel is defaultuser then certain items on the form will not be shown and in instead other details are i have tried the following but cant get it to work. select case vlevel case "default user" credit details.visible...

I have created a report that has everything i need and layout. however when i try to send it as an email via an rtf or html document it loses it formatting. Eg. the lines i have drawn the logo and the tick boxes for fields. does anyone know how i can email the report so that it doesnt lose any...

How can i export the contents of a form or report to an email so that someone can fill in the relevant details but the recipient cant change the formatting. Can anyone help

I need some help in printing a report from a form that the person has just a filled in. The print this record button doesnt work as i only prints what you see in that form and as i have tabs on my form it wont print all of it. I thought about after the form had been filled in and the print...