Search results

Here is a function that opens a browsing dialogue box and should give you what you need Function dialogFolderBrowse() As String '##### This function gives the user the facility to browse for a file or folder and to be able to use the path '##### as a destination. '##### You must...

could you post the code you use in your GenerateCountryQuery() function The only thing I can think of at this stage is that this function is returning, for whatever reason, some rows that are blank in the CountryName field and they are top of the list. When you expect only one country to be in...

I have a similar situation in one of my databases and there's no problem in the display of the 2nd cbx even if only one record in the second. Have you checked any criteria used is working as you expect, also may need to check the properties of the cbx David

are you saying the csv file uses a ~ as a delimiter, if so start by doing a manual import and once the wizard opens choose the 'delimited' as the type and 'Other' as the delimiter and type a ~ in the 'other box', if there is a text qualifier, select from the list, then click on the advanced...

Am I right in assuming the region cbx rowsource is dependent on or set by the overseer, so if the overseer selects a region from the list, is the country cbx supposed to display all countries containing the selected region, if so can't you reset the country cbx rowsource based on the selected...

have you considered just using the in-built record selector from property, clicking on this will highlight the entire row David

couple of things to check: do the users have the same network permissions, try letting the OK user log on to the machine that is failing do the pc's have the same O/S are they both running exactly the same .mdb file David

using Format(Now(), "mm/dd/yyyy hh:nn:ss") should always work

To prevent repeating random numbers (or winners), you'd need a table to store the valid random numbers that are generated and do a check similar to the loop I suggested above only the check would would be against the previous random numbers table. I don't know how many in your pool but using...

I don't know of any Access output method that will do what you're suggesting. I know of other reporting tools that will create this hierarchical view, the nearest thing I can suggest in Access is a simple report that is grouped by Invoice number but it doesn't have the expandable tree view...

Bob's code will work even if you have numbers missing and they are not sequential. The only adjustment you need to make is to do a check that the random number generated exists as an ID in the 500Club table, if it doesn't try another random number and you can operate this by putting the code...

that should read DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EXPORTDATA", "c:\EXCELSHEET.xls", True, "A1:D10" David

How many fields does your table have and do you know how many records? All you have to do is add the range argument i.e. a table with 10 records and four fields would be DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "EXPORTDATA", "c:\EXCELSHEET.xls", True, "A1:D10" David

what kind of server are you trying to connect to? maybe this link will help: http://msdn.microsoft.com/en-us/library/office/ff821690.aspx David

try this to see if your GetUserName is returning a value Dim userName as String userName = GetUserName With Me.OLE1 .Class = "Excel.Sheet" .OLETypeAllowed = acOLELinked .SourceDoc = "C:\Users\" & userName & "\Desktop\Database\Excel Files\Bulk Updating.xlsm" .SourceItem = "R1C1:R5C5"...

can you post your code on how you're dynamically changing the ForeColor and BackColor for: 1) the objects that work ok 2) the objects that don't work David

yes, from your original post I would say CombinedFields was a function or sub from where ever you lifted the code. You could modify your form and add a new unbound textbox, name it CombinedFields and Pr2's code should work David

you may also need to swap the order of the GROUP BY and WHERE clause. Generally SQL statements will be structured like: SELECT ... FROM ... WHERE ... GROUP BY ... David

have you tried debugging it to see if there is a value returned by GetUserName David

Hi SSgtFranklin, this is as you say "quite complex" and I'm not suprised you haven't found anything that fits your needs as it's quite bespoke and would require a significant amount of development to achieve what you've outlined. I think it's fair to say this forum is designed to help those that...