Search results

I have a listbox that gets the data from a query. It is possible that the query doesnot return any rows. But when I double click the listbox, I need to check if there a row in the listbox. How do I check if a listbox is empty??

I have a form whose record source is a query. The form has a list of textbox and listbox controls. When I create a row in the listbox, I add a empty record in 2 tables. One is the table attached to the form itself and other TableB. When I type the data in all the textbox controls, I need to...

Dim CurDB As DAO.Database Dim MoveWorksheetTB As DAO.Recordset Set CurDB = CurrentDb() sqlQry = "SELECT * FROM MoveWorksheets WHERE MoveRequest_ID = [Forms]![EditMoveInfo]![MoveRequest_ID]" Set MoveWorksheetTB =...

In my company, the users use the MS access application. Sometimes, the users get the following error "You cancelled the previous operation". After I see such error, then I have to reinstall the GUI and the problem gets fixed. I dont know if it is the sequence in which they open the form causes...

I want to print the m/c name in the report's footer so that the users know to whom it belongs when they go to collect the print outs at the printer Is there a standard function to print the m/c name in the report footer? Thanks

I am getting an unrecognized database format once in 2 weeks. In my company around 45 users access the database that is replicated in each user's m/c. Then I have to Repair and compact the master database to fix the problem. Any ideas of why it is happening??

I am having a listbox in the report footer. I would like to change the row source of the listbox dynamically. Where should I add the code to specify the listbox rowsource. I tried adding the row source property in the reports's detail print and report footer print.. Nothing worked out...

I call a function from a query to calculate the time difference between 2 events in a way I want to implement in our process. If the startdate and enddate fall on the same day, then I want to calculate the difference in terms of hours. The startdate is like this 11/21/2002 8:04:25 AM and...

I have a crosstab report and when I print the report, the totals in the report footer are getting doubled. What i see on the screen is Total 700 2 3 5 But when I print the report, in the print out , I see all the data correct except for the report footer info it is Total 1400 4 6 10

I have a parameter query that accepts 2 parameters. If one parameter is 2 , then I donot want to check for the second parameter valus. Is there a way to do it ??

I have a textbox control and it has a specified width. But if the number of characters are more to display in one line, then I want to wrap the text in the textbox. The text that appears in the textbox is determined at runtime. Is there a way to do that??

I have created a crosstab report and since all the headings are dynamically generated I am not able to see the full column heading. I have maximum of 15 columns that appear in the report. I cannot make my textbox size to be bigger. Is there any way by which I can wrap the text in the textbox??

I have a listbox that I fill with the result of a crosstab query. Since I have to add up the columns of the listbox columns I added code in VBA and stored the result in dynamic array and created another listbox below the first one. For the second listbox, how do I feed the dynamic array input...

I have a crosstab query that produces varying number of columns. I feed the output of the query to the listbox. I need a total of each column. Do I have to do a lot of programming of looping through and finding the sum? Or is there anythere way to do tha?

I got some code for generating a dynamic crosstab report. I am able to see only one row in my report. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim intX As Integer If Not mrstReport.EOF Then If Me.FormatCount = 1 Then For intX = 1 To mintColumnCount...

I have a crosstab query. Its output is like the following DeskNo Total NChurn VoicePortion VoiceOnly I would like my output to be the following DeskNo NChurn (VoicePortion-VoiceOnly) VoiceOnly Total How do I accomplish my goal?? I have 1 idea. Loop through each record of the...

I alreay have a result of a crosstab query. Then from the output of the crosstab, I have to subtract 2 of the dynamically generated column values and then display in the listbox. So, i want to scan the query output add to the listbox. How do i do that??

How to i add a row to a listbox using VBA?? AddItem property is not avaible as the listbox property?? How do i do that??

I found the way. Thought it will be useful to someone... here is the code to do that... Set db = CurrentDb() Set qrd = db.QueryDefs("testunion_Crosstab") Set rstSource = qrd.OpenRecordset(dbOpenDynaset, _ dbSeeChanges, _...

I am trying to feed a crosstab's query outpout into a listbox. But my column count will differ according to the query result since it is a crosstab query. How do i find the column name of the crosstab query in VBA?? For Example if my crosstab result is like the following with 5 columns...