Search results

Hi, Is the row source for the listbox set to allow all records to show. Is it possible that the null records are missing? You can check this easily by seeing how many items appear in the listbox, against the number of items in the table/query you are using. You don't need to use IsNull(...)...

Hi, I haven't had time to look at the code thoroughly. The RGBFromLongColor procedure is attempting to modify the values of iR, iG, and iB respectively. This works because by default access passes the variables by reference (ByRef). When the variable is changed ny RGBfromLongColor the modified...

Hi, It looks like there is erroneous text in the procedure name. Try removing the space and "RGB" from the procedure name Change this: Sub RGBfromLongColor RGB(lColor As Long, iR As Integer, iG As Integer, iB As Integer)toSub RGBfromLongColor(lColor As Long, iR As Integer, iG As Integer, iB...

Hi, I use an older version of access and I think the database provider you need for Access 2007 is different, so the connection string should be: cn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myfile.accdb;Persist Security Info=False;" Have a look at this...

Hi, Just a quick thought - does the file path include spaces. In this case I think you would need to enclose the path with quotation marks. Try this: cn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; " & _ "Data Source=" & chr(34) & "c:\myfolder\mydatabase.mdb" & chr(34) & ";"

Hi, Welcome to the forum. Some would say there is no such thing as a stupid question. There is always somebody here who can solve problems, seemingly no matter how hard or trivial. Good luck learning!

Welcome to the forum. I have made a similar transition in the past from using Excel to Access. For some tasks it makes life much easier, but there is definitely a learning curve. The folk here making learning a lot easier though!

Hi Dwayne, Welcome to the forum. There are many experienced, efficient, friendly and interesting folk here, so there should be both answers and chat!

Re: copy table as many times as related fields ex-> name of copies same as related fi Just to clarify one more thing, is there: a) a field in the hobbies table called something like "hobby" where the entered values are "hobby1", "hobby2" etc OR b) a number of fields called "hobby 1", "hobby 2" etc

You are very welcome, glad to be of service.

Hi, Sorry I forgot to mention one vital piece of information. In order to use ADO from Excel you need to reference the activex data objects library file. To do this: open the VBA Editor (ALT+F11) go to the Tools menu and select References Scroll down the list until you reach "Microsoft...

Hi, I have searched on Google and found this, which does what you are after. The only way this differs from your code is that it creates a range object first, and then changes the text of the range object, rather than selection. I had not appreciated that the bookmark is deleted when...

Hi, When you use a totals query you can group by a certain field. In this example you can group by the object and then sum the quantities for each object. I have modified the sample database so you can see.

Hi, Having a closer look at the code I am a bit puzzled. It looks like you select a bookmark and change the text which makes sense. The next line appears to be trying to create a new bookmark with the same name. Could you explain what you are trying to do here and maybe we can find an...

Hi, Have a look at the attached file. It is a bit of a meaningless example (well made up anyway) but it should show you how to create a subform based on a totals query.

I'll try and knock up an example of what I mean, it might be easier than trying to explain in words.

Hi, I'm not entirely sure what is going on without taking a look. You could try forcing the textbox to update when the value in another control is changed using the afterupdate event for the other control e.g. Private Sub OtherControl_AfterUpdate() Me!CalculatedTextboxName.Requery...

Hi, This should be possible by creating a subform based on a totals query, or by VBA code that calculates the totals using DSum and displaying them on the form. Could you possibly upload a sample database and I'll take a look for you.

Hi, I am not sure if this will resolve the problem but I cannot see anywhere that you close the document. I would be inclined to use ActiveDocument.Close after you save it. Secondly I think you have to use Application.Quit rather than Application.Close. try this: pStr = pStr &...

Hi, The messagebox suggests that vvalues is an array, so I think you should change the line giving the error to Me.cmdlistIcp8_FNewMsn.Value = vValues(l)