Search results

The following code works fine Dim RaRound Dim I RaRound = DCount("[Initials]", "Inbound", "[Initials] = [Forms]![Inbound]![Initials]") 'MsgBox (RaRound) For I = 1 To 2'Len(RaRound) MsgBox (I) Next I However this doesnt Dim RaRound Dim I RaRound =...

Ok I understand that tables are limitless but I was actually trying to create a one page form of questions each question was about 4-6 lines long in text and then a empty box underneeth for an answer that was about 5 lines in height and there was about 35-40 questions so as you can tell that...

I am useing the following code to send email reports and I was wondering if there was a way since it knows how the email is going to that it would just send the email without opening outlook and the user having to hit send! :confused: Private Sub Email_Helpdesk_Report_Click() On Error GoTo...

I dont know why but I get an error when trying to open the zip!:confused:

So did you use Java to build that GUI in the picture? Also is there a program that someone can direct me to that will help me learn java visually? I mean if java is a gui there must be a gui to make java?

Ok Cool you will have to show me somesort of sample as I found this link http://www.databasezone.com/techdocs/acclimit.html which indicates that the max a form can be is 22"

I am creating a tab control with 4 tabs and I was wondering if there was a way of either putting the tabs in the header of the form so that when you scroll you only scroll whats in the tab or a way to hide the tabs then I could create buttons that would change the page in the header??:confused:

I was going to ask what GUi would you sugest for your database stuff? If not access what?

Is there a limit to the length of a form? (Hieght or Width)? :confused: :confused: :confused: I was trying to create a quiz for work and its giving me the following error as I push things down the form The number you entered from the Left, Top, Height or Width Property is too large or is a...

Very Very Excelent Advice thankyou :cool:

How woudl I go about doing that I tried this but it didnt work SELECT Employees.Initials, Inbound.Inbound_ID, Soft_Skills_Inbound.Inbound_ID FROM (Employees LEFT JOIN Inbound ON Employees.Initials = Inbound.Initials) LEFT JOIN Soft_Skills_Inbound ON Employees.Initials =...

Ok well that did speed it up, and it is much faster now :)

So more like this SELECT Round(Avg([Percentages_All].[Percentage_Both_In])) AS [Inbound%], Round(Avg([Percentages_All].[Percentage_Both_Out])) AS [Outbound%], (([Inbound%]+[Outbound%])/2) AS [CCC%], Round(Avg([Percentages_All].[Percentage_Both_Data])) AS [Data%]...

Can anyone sugjest a way to make this query load faster when there is a lot of data? SELECT Round(Avg([Percentages_Inbound]![Percentage_Both_In])) AS Inbound, Round(Avg([Percentages_Outbound]![Percentage_Both_Out])) AS Outbound, (([Inbound]+[Outbound])/2) AS CCC...

Ok when I open a form from another form I use the following code =[Forms]![QA_Index]![CCC] to get the default vaule in a text box problem is that I have more then one choice of dropdown and I need that to change acordingly where if I choose ccc the its ccc if I choose IRO then it would be IRO...

Ahh I see the error of my ways! :rolleyes: Thankyou:D

nevermind I figured it out! lol looked it up in my book Says to do the following 1. Create Label 2. Select Label 3. Cut Label 4. Select control (text box or combo box ext...) 5. Select Edit -- Paste and presto you have a Label attached to the control :D

Now by default Access when you create combo box it creates a Label to go with it and they are linked together, I was wondering what controls that and if I have removed the label and create a new label where can I link it to the combo box????:confused:

So I have created a query to email a single report based on the data I have open in the form! problem is that when I click on the button to email the report it ask me what the Inbound_ID is I want that to be carried over for me how would I go about doing that???? Ok so here is my query! SELECT...

Ok I think I understand what you are saying however if the report is being called from a query it would make more sense to put the criteria in the query correct?