Search results

I have written some code that generates a Batch File from Excel (2003) to copy a Backend File and another db file. Then I call a macro in the db file that relinks it to the Backend file on the users desktop. This was to speed up the process of pulling data. If I step through it it's fine but...

Hey Galaxiom, I am doing several calculations in my subqueries and when I pull the Plan % number it's right on but when I pull the Actual % it's not good. The numbers aren't matching. For instance I have one entry that should be 0% but it's returning a value of 4.08%. But, when I create a...

Hi All, Awesome Forum hoping some day I can help but until then I'll keep asking dumb questions. I'm pulling data into Excel (2003) from Access (2003) using ADO and the data in Excel is incorrect. I run the Query in Access and I get the correct # when it ends up in Excel it's not correct. I...

Not sure if this is the best way but I just put an Error Trap in On Error GoTo ErrExit cnt.Open strconn . . . . Exit Sub ErrExit: Err.Clear Resume End Sub

Howdy, Currently, I'm using an XL file (2003) that copies my Access BE file (2003) to the users Desktop and another Access.mdb with Queries and linked tables to the BE. I then execute a macro inside the db with the queries to relink the tables to the users Desktop. Then using ADO I pull data...

Not sure if my quetion goes in this section but I'll give it a shot. I currently have managers entering their daily production numbers (Access 2003 FE/BE) and at the end is a summary form that "spits" out the results and they are required to enter information as to why they didn't achieve their...

Well I got it to work. I ended up doing this... Function RemoveCharacters(x As String) As String x = Replace(x, """", "''") x = Replace(x, "+", " plus ") x = Replace(x, "/", " ") x = Replace(x, ",", " ") x = Replace(x, "&", " and ") RemoveCharacters = x End Function Instead of this...

Hi All, Again thanks for the assistance. I tried all the above mentioned and it didn't work. I'llput the replace function in the SQL statement and hopefully that will work. I just thought this would be cleaner.

Thanks for such a quick reply! Here is a snippet of the code stryieldroot = Nz(.txtyieldrootcause.Value) stryieldroot = RemoveCharacters(stryieldroot) stryieldca = Nz(.txtyieldcorrectiveaction.Value) stryieldca = RemoveCharacters(stryieldca) Here is my function to...

I have an Insert Into Query and an Update Query that will bomb out if the user enters double quotes. I was thinking the syntax was Function RemoveCharacters(x As String) As String RemoveCharacters = Replace(x, """", "'") Obviously this isn't working as I planned. Any information would be...

Sorry after reading the article a few more times it's just saying in a multi-user environment use forms to input data not tables:o. LOL I at least understand that.

Hi guys, Thanks for the comments. I checked out both articles and for the most part I'm doing all of those things. The only things I'm not doing is creating a shortcut on the user's desktop. I'm using a .bat file to grab the updated FE on the network and pasting it the user's Desktop then it...

Hi All, Awesome forum I'm in here all the time browsing for goodies and getting help so for that THANKS! I created a FE/BE db in Access 2003 for my work and when 1 person opens it shazaam no problems as soon as another person opens it the forms open slow and the time for reports is increased...

Howdy all, Just a quick one here. My company has an automated scrap system that is currently storing the results in MSSQL 2005 located on someone's C Drive. I have created a database (FE/BE) to store production data and I would like to tie in the automated scrap system. This computer is on...

Sorry, yes I did make it landscape. Font size was 8, so it's already pretty small. I have made a subreport, but thought there was an easier way. Thanks for the help! At least I know there wasn't something I was missing.

Hi VBAInet, I've done that already (reduced font). I've even created a subreport that would contain the second set of information. I just thought there would be an easier way to do this and have it look nice.

Hi All, I've never messed with Access Reporting but it seems cool if you understand it. I don't! I have approximately 20 or so fields to report. I'm grouping by Date, Product Line, and Shift, and Product and since there are so many columns it stretches across 3 pages. How can I get my report...

Hi guys, I realize this is a bit late but I've been gone for a while. Prison is nasty, :D Only kidding. Of course the proposed fix worked perfect as usual! Thanks a bunch for the help!

Hi all, I'm pretty unfamiliar with working in Web Queries and I'm trying to understand how to pass the variables so I can access the information. Here is the source on the web page - can someone get me started on how to pass the Username and Password? </script> <body...

OK, I'm starting to be somewhat freaked out. I have tried over and over to save a .xlt file in the XLSTART folder but for some reason it kept going to the Templates folder inside the START folder. Today I just tried it again and now it appears to work. Maybe I need to lay off the booze at...