Search results

I think you'll need to post more code in order to see how the current form is being closed. "what can i put for it to just close the msg box" These close automatically when you click Yes/No/Cancel, but we need to see what code is executing after the Msgbox code David

because of the relationships between Marketing Events/Owners/Shops being : Many to Many to Many, you can't display all the data without repeating data. You could have your Events form and use a sub form to display each owner (using single form display and navigation buttons, not continuous) and...

I think it's the DSN that's causing the problem, instead of the C:\Users... just enter the name of the DSN that you gave it when you set it up on the machine (look in your ODBC manager) Failing that a better way would be to use a DSN-less connection string David

You should just be able change your MYOB_Update query to an Update query and in the 'Update To' row for field Test1 write Format(Date(),"dd/mm/yyyy") and in the field 'Updated' write True All you need to do is run the query using simple VB such as: Docmd.OpenQuery "MYOB_Update", acViewNormal or...

Judy, when you say "someone selects an item from this combo box, it gets the value then searches..." Is there a reason why you can't develop this whole thing in Access as it does sound like you're taking data from Access to Excel and back to Access or am I missing something? David

Judy, I suspect you may need try a different approach such as opening the Excel file, create a connection to your database and then write the values from your form back to the database using some SQL. It is possible to run Excel and open a file from Access, but I've never tried referencing form...

Hi Goldfish, you might want to rethink your approach "I want to create a module that will open the excel files and retrieve data from Active X combo boxes, option buttons .... " When you open these Excel files, unless you are running some funky start up code from the Workbook open event, these...

Perhaps you could try approaching this from a different angle, what does the report contain? Maybe you could use the report source to populate the email body, how you'd go about this depends on what is in the report. David

When you say you've installed a new HDD, is this just on the local machine and the location of the BE file still the same as before presumably on some server elsewhere. If so then the .mde should still be connected to the BE .mdb file and I'd check the path in the properties of the shortcut, try...

you're welcome :)

Presumably the links you created from your query for each personnel are stored in a table and you say it is displayed somewhere, is this on a form using a text box, if so you can add a small button and use the OnClick event to execute the code above. It should be something like If...

You could try using the Dir & MkDir to create the folder and the FileDialog object to open a dialogue box which will go straight to that folder. Creating a folder (if it doesn't already exist) is quite straightforward, If Dir("K:\Main Breakdown\Section Breakdown\Personnel Folders\Name "...

have you considered using DSN-less connection strings. This would negate the need to set up ODBC on local machines (much less maintenance), also easy to switch the FE app from DEV to QA to PROD simply by changing the server/database names David

"As far as my original query goes I'd like to make a summary page that would show a lot of info about the database" Depends whether you intend to keep a history of these values, if you do then a simple table with a field for each value would do the job, include a date/time stamp field. Each time...

I would just add in relation to your headline Query vs Recordset for returning values Recordsets are better suited for processing, ie performing actions while navigating through a recordset. Queries or SQL as suggested above will work fine to display criteria based record collections and return...

a better way would be to use a Case statement I'm assuming "dev", "admin", "sprvsr" are string values, not variables, if the latter then remove the double quotes Select Case strSecLvl Case "dev", "admin", "sprvsr" If MsgBox("Do you wish to clear the logs?", vbYesNo, "Clear Logs")...

Someone brought up the possibility of writing SQL to generate a query then export the query This sounds like the way to go, if records are available through a sub form, then those same records can be queried using your subform linking criteria. You don't say what you're trying to do with the...

Maybe you could query & extract the Subject line data from the selected emails and use that data to create records in an independent table in your TPH Utility and use that table to do your analysis, that way the original email remains intact and unchanged. I see that you can edit the subject...

another suggestion might be to build the functionality into the Excel workbook itself by setting a connection to the database, define some SQL to query the required data and as pr2 suggests use the CopyRecordset function to dump it on to the worksheet in the next available row. David

These hyperlinks, presumably they are a value held in a field in a table, are they to a shared drive/folder location which every user & workstation has access to. Sometimes users shared drive mappings can be different even though the target folder is the same David