Search results

WOW do I feel stupid. Been looking at that code for a few days now, did not even notice the lack of the (). Sigh, getting too old for this.

The macro is : RunCode, with MakeExp in the function name field. I have been wondering, if there could be some sort of corruption in the avvdb. If so what would be the best way to test/fix?

I do get the same error message, with a function. The reason for a macro is just to test. Been having a few little problems, and thought this should work for sure.... but it doesn't

I have a temp macro that has one step: Run Code : MakeExp Inside my Module1 I have the following: Public Sub MakeExp() Dim rs_in As DAO.Recordset Dim rs_out As DAO.Recordset Dim strSql_in As String Dim strSql_out As String Dim ExpName As String 'Path and name of text file ---A ton...

Hi guys, thanks for all your assistance, in the end I am going to blame it of lack of coffee! The reason I was having so much trouble with the 'update' command, was simple, I needed to use the APPEND command! Now everything is working quite smoothly.

Here is the SQL that is giving me the grief. UPDATE Roll SET Roll.[muni-no] = Mid(([RawData_01]![InputText]),1,3), Roll.[roll-no-type] = Mid([RawData_01]!InputText,4,1), Roll.[roll-no] = Mid([RawData_01]!InputText,5,9), Roll.[record-type] = Mid([RawData_01]!InputText,14,2), Roll.ward =...

I am trying to write an update query. There are 1/2 dozen to a couple dozen fields in the various tables in question. The raw data is sitting in an access table with 4 fields: ID automatic ID Text1 Char(255) first half of the import files line Text2 Char(255) second half of the import...

Sorry to take so long to get back, I had to do a bunch of restores of my test data.... I miss spoke, where I could move the file from drive D: to drive S: through Explorer, then VBA issued the command: FileCopy "d:\SQL-Ledger\SOWO-Export.csv", "s:\SQL-Ledger\SOWO-Export.csv" The program crashed...

I am outputiing to a text file. I did try writing to C:\ And that worked perfectly. guess i could create the file on C: then move it later.... not ideal but would work. And yes my id has full control over the entire S: drive.

Looks like that is the issue, a security issue. How do I tell Access to write to drive S: like always. Drive S: is a Samba share on a Linux server. This drive can not be changed, as this is where another program is looking for the file once it is created. Any ideas how to fix this...

I have been running this code in production for over 2 years now, works like a charm until today in my development environment, sFName = "s:\sql-ledger\SOWO-Export.csv" iFNumber = FreeFile Open sFName For Output As #iFNumber I did check, drive S: is definately there, the directory \sql-ledger\...

Done and added to both your reputations! Thanks again, would not have thought of solving the problem this way!!

I got rid of the extra field, not the form is callable from the VBA code. YEAH!!! Then I try and call it from a Macro right off the button it still does not work. I get the: Function not available in expressions. Error. Not a great deal, I can just add a snippet of VBA code instead of a...

I tried that out, I have copied a screen shot of the error I am getting on the OpenForm. The field Order_Number is correct and the only one in the query. Hmmm the paste of the screen shot did not show up. I am getting an error 3079 The specified field 'Order_Number' could refer to more...

Ah sounds good, let me take a stab at this and see if I can get it working. Will make the end user happy not to have to type in the generated order number.

Sorry nope never used the "inputbox()" function. Looked up the syntax, so are you thinking of the button what opens the form and needs to prompt does an openform where number = inputbox(), and the other places openform where number = the_variable_already_known? Something like that. And...

I think that is the problem I have the where conditions in the query itself: SELECT PartsWorkOrder.*, PartsWorkOrder.Order_Number FROM PartsWorkOrder WHERE (((PartsWorkOrder.Order_Number)=[Enter Order Number])); There are three buttons on a form, one of them the user presses and is prompted for...

Still working on it. I am still a little confused how to get a query to behave in two different ways. Or am I going about this all the wrong way?

I sort of get that, where I am hung up is how to I get the openform to prompt in one case, and in a different case prompt the user for input. I know this must be pretty easy, and I know I am going to kick myself when I see how. Right now I do not quite get how to do this :(

Right now it is embedded in the query that the form uses, this can be changed if required.