Search results

Thanks Ranman256, where would I put the location C:\Users\Desktop\Daily Work Project Folder\Rene Time Card Can you show me by using the DB I attached

I have a list of 30 files I need to import into my access database. The files in the folder are named 1. Txt 2. Txt 3. Txt 4. Txt 5. Txt 6. Txt 7. Txt 8. Txt When I did the first import I did it by doing an import text file, located the file 1.txt. The Import Text Wizard opened and I picked...

Hello All, I have a query that does a great job at fining duplicate master records I'm hoping someone can help me add to this query so that it fining duplicate master records like the query show and add one more record that will link up as shown in the example. If you need any more...

For the past year I’ve been saving some really great VBA scrips that people have helped me put together. Now that I’ve saved all these wonderful VBA scrips in folders as .txt files I’m wondering if someone has been able to put together a macro that can be called from either a excel, access...

How do I view all my Post from this site?

HI, I’m working with MS Access 2013. I’m looking for the Macro that allows me to export a query to a .csv file. Did they remove this from 2013 or is it called something else? Thanks

I’ve been looking for a Macro I can run execute off a form that will open my Windows search box that shows folders and my network connections on the left hand side that will let me import either a Excel file or a .csv If there isn’t one could it be done in VBA? Thanks for your time and help

Hi, I’m running access 2013 and from what I read with this version of access we’re no longer able to create pivot tables or charts. Does anyone have any work around or examples that I would be able to create some time or work around? Thank you

I’ve been trying to do a basic pass thought query. But have been receiving these two error messages 1.ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#102) Error message 2. ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL...

Can someone help me find out why I'm getting this error message? ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'tabel name' (#208) Thank you

Hello everyone, I’m looking for a list of Pros and Cons about splitting a database. Does anyone have one or able to put one together for me? We are using MS Access 2003 Thanks TCB

Hi everyone, I got a new computer with Microsoft Access 2003. I’m working on a form in design view and have the I'm magic wand turned on but every time I select tool box and chose example combo box or option group The wizard doesn’t pop up. I’m searching the internet now to see if I can find...

I thought I knew how to do a weighted rank but I'm having problems with the results. Could someone please provide me the calculations to do a Weighted Rank and a Weighted Average? If you need more back ground, please ask. Thanks TBC

Thanks CBrighton I was able to get it to work by adding a quit maro on the timer

I have code that will pop up a message on someone else computer when I change the trigger. The problem is that it should also do a count down and after 3 minutes close who ever has the database open. I’m using Code A in the properties for a form “frmSwitchboard” in the “On Timer” and set the...

Thanks Guus2005, can you should me an example?

CBrighton, Thanks again for all your help. Everything is working except the last part. The form opens up and warns the users, but doesn’t automatically close Else ' Count down variable is true so warn ' the user that the application will be shut down ' in X number...

I'm now able to get the flashing warning. could I be missing another step?

CBrighton - I dont the database to flash the warning but the database stayed open, what other step might I be missing?

No I havn't, Do I open this one frmAppShutdownWarn or this one frmSwitchboard