Search results for query: *

Hi You can do this manualy, by creating a NEW database and selecting the objects from the source database you want to import. when you import tables just import data structures and any "autonumber" fields are reset to default. hth Robert Robert Dwyer rdwyer@orion-online.com.au

Hi Paul, i have had this as well, i developed an application on an NT box, and it had this problem on 9x box's you need to check out the references that access uses. edit a form on one of the user's machines. goto the VBA code and from tools|reference menu check what reference's are being used...

Hi, well the function would need to initialize the value between calls, unless you made the function to hold the value between calls using a Static type, but that would need to be initialized when first called, then the value could be used during the running of the program. The other problem...

Hi Brandie, Ok i don't see anything obvious, could you try to include some debug code to display the values Me.Left Me!LeftMargin Me!OrderDate Me!ColumnWidth either try the debug print or add text boxes and assign the values of these items ahead of the if statement to check that they actually...

Hi, I have not had this but have fixed other funnies (tar ms) by creating a new db and importing all of the objects from the suspect db into the new db. just a thought,... regards Robert Dwyer rdwyer@orion-online.com.au

Hi if you have a report based on a query and change the query then the data available to the report may have changed. if you referenced the OrderDate field in the old report and it dosent exist in the new query then that could be the problem Error Code Error String 2465 Invalid...

Hi, maybe consider writing a function that preforms a similar function to left$ but with some smarts. like it needs to return the first 7 digits if and only if the suffix is a simple "-C" or "-ISA" however if the suffix has a "-*-" you would want to return the 7...

Hi David, do you have any link criteria set for parent and subform?? if there are no records that match you will get a blank form! if the link doesn't match. if you do and the data has been changed you may need to do a refresh either by code or just the menu|records|refresh regards Robert...

Hi i take it you want to apply the filter by clicking a button on a form i have used the following code attached to a form to filter the subform Private Sub ShowReconciled_Click() ' Robert Dwyer 5-Dec-2000 On Error GoTo Err_ShowReconciled_Click ' Togle between Reconciled Only and All Records...

Hi Let me see if i understand the situation. You have a form that displays some information? After the user fills in some details they get to a yes/no field. If the answer is no they simply continue with what ever they are doing. if the value is yes, you want to pop up another form to get...

HI Just a thought, break your problem down try to identify the total stock of parts already on hand with a Total's query. when you get the leftstr() function to group the items and extract the totals for the base part of the part number. make another query that compares the totals from the...

Most likely the user's access program is opening the the database on the server in exclusive mode, to check this you need to goto the users pc, start access and open the database (any database will do) this allows you to select tools|options from the menu goto the Advanced tab on the options...

Hi if the sub has no arguments just use the name of the subprocedure yourSubProcedureName if it has arguments Call yourSubProcedureName(Arg1,....ArgN) Robert Dwyer rdwyer@orion-online.com.au

Hi fusion786, I don't quite understand your structure here as you seem to repeat unneeded data. but if you base the Invoice details on a query, in the query join the two tables together on supplier code and have invoiceDetails.SupplierCode, CustomerName.CustomerName...

Hi bear with me i havent touched access for a while snip---- On Error GoTo Err_cmdlogon_Click 'try Dim strPassword as variant Dim strTemp as string 'Dim strPassword As String strPassword = DLookup("[Pword]", "tblPassword", "[UserId] = '" &...

No not at all, it's all part of the learning process. access has its draw backs but relational databases for the time are the best, wait for object databases ;-) see ya Robert Dwyer rdwyer@orion-online.com.au

Hi Pete, No, but there are some limitations (oh great you say!) in this situation you might like to re-think how to acheive your aim for instance you want to start with all but the first field locked if i presume correctly. create a function called by the subforms On Current event that...

Hi Markl this is a little long winded but the approach has advantages dim mySQL as String mySQL = "INSERT INTO TableName ( Field1, Field2, field3)" mySQL = mySQL & " SELECT " mySQL = mySQL & Me.FormControl mySQL = mySQL & " AS Field1,&quot...

Hi Deedlebug, mmm school project,... Ok firstly lets look at a few basics for the orders we need to collect certian information. like for the order we need to know how who and when. so we have a table that contains for example CUST-ORDER OrderID Key CustOrdNr CustID OrderDate then we need to...

Hi Adam, do you mean that the data source for the form has a reference for SystemID in the data source?? ie if you goto the datasource and look at the query grid there is a reference to the other table, if so you will need to remove it access would be looking for the table to return data from...