Search results

I have a database that i have used for many years, which I use to analyse my bank statement which is in an Excel file. The query uses some code which uses a Combo box to look at a particular category to analyse. Here is the code: Public Function fCboSearch(vCboSearch As Variant) If...

I have just been trying a few things, but looking at what you have said the list would be enormous. I have 46 card sizes, and if I had 10 fonts, 10 Font sizes and 10 colours, that would be 46000 permutations. I had better start learning VB or C#! Thanks all the same.

I have though of a way to still use the database, but it's a tedious way around the problem, which I discounted when I started the database. I could have a report set up for each of the card sizes! The only disadvantage is that the user would not be able to alter the Top position, which I...

I am really disappointed that there is no solution after spending hours of work and that of Sneuberg as well. Could some of the code be used in a Visual Basic solution? How can you produce reports in VB? Or could the text be output as a PDF? Any thoughts on these ideas?

Thanks Sneuberg! All that work you did and looks like I can't finish the problem in Access. Do you think that some of the code would work in Visual Basic, with some corrections?

Hi Sneuberg Fistly, The best I can do with Zipping the files is 2.14Mb, and thats also splitting the database with that database splitter. I have heard of Crystal Reports but never used it. Have you any tutorial information? How will that help? If you want a copy of the database so far can...

Hi Sneuberg I could not find where the code was called, so I just commented out the sub routine. I ran the code as accdb and it worked as normal. (Font size and color changed as expected). The report printed correctly. I then changed the file extension to accdr. I then ran the test and...

I was editing the post, but took a long time. I carried out further tests as you will see below. Tried to zip the files but each one is 2.3Mb, so can't send via forum. Is there any other way of sending them to you? Hi Paul or fellow Access users I have just experimented with the working copy...

Hi Paul or fellow Access users I have just experimented with the working copy (suffixed: accdb) and made a copy and changed it to a Runtime version by changing the suffix to accdr. Before the change it worked OK, but when I changed it to Runtime version it printed the form instead of the...

I found that by default the wizards ar not installed. Had to go to installed Programs, Office 2010 and chooose Change. Then in the Add-Ins tick against load onto local drive. Have another problem and I am not sure this is the place to air it! Having packaged the Access Database and installed...

Your spot on! Have 64 bit PC and forgot to add Ptr onto all of the long number types. I really want to package the database and according to the web under Save & Publish there should be an Icon for package and distribute, but it is missing on my copy. There is a button Package and Sign, but...

I have created a database that I want to make a Runtime version from. I have gone to the Save and Publish and clicked on Make ACCDE file but when I save as it reports: That it is unable to create an accde, .mde or ade file. Looking at the help it suggests there might be too many tables. I have...

All sorted! Put sub-routine back into module, but had to add, the new argument for the color: Public Sub ChangeReportProperties(strReportName, strFontName, strFontSize, strForeColor) DoCmd.OpenReport strReportName, acViewDesign Reports.Item(strReportName)![Text1].FontName = strFontName...

Right! The sub routine I removed needs to go somewhere and not the Module. I have lost track of where it needs to go, luckily I copied it to Word.

I have this in Module 1 as well: Public Sub ChangeReportProperties(strReportName, strFontName, strFontSize) DoCmd.OpenReport strReportName, acViewDesign Reports.Item(strReportName)![Text1].FontName = strFontName Reports.Item(strReportName)![Text1].FontSize = strFontSize DoCmd.Close acReport...

I'm getting a compile error on Module 1 saying: 'Only comments may appear after End Sub, End Function, End Property' on the line: Declare PtrSafe Sub wlib_AccColorDialog _ Lib "msaccess.exe" _ Alias "#53" (ByVal Hwnd As LongPtr, lngRGB As LongPtr) Not sure why that is?

I'm not clear on step 3. When you say right click on Frm_Verses_Mstr do you mean for the whole form i.e. click on dot in top left corner or do you mean on the textbox, if not there where do you click?

Obviously an error, but where should the double quote go, if one were missing, surely there would be an odd number of double quotes, but I count 8?? The error I get: Expected: Expression Any ideas?

Got a message 'Not enough Arguments' Realised that the sub routine in Module 1 had 3 arguments, so just added the Font size argument on the end of the line: ChangeFontName "Rep_Port_Grt", Me.CboFonts, Me.CboFontSz Now want to set the Font color! I'm sure I have seen some where that you can...

Right I found what to do. I added Ptr to all of the Long calls. Works OK. I want to also change the font size and color. Can this be done using this technique? If so not sure how to do it!