Search results

I wouldnt use the DCOUNT function, Dcounts and anyother D functions are very much a bad thing that you dont want to use. Also concatinating a number and a date field on average is a bad idea, made worse by not explicitly formatting the fields to strings. If it works it works, but implicit...

How about create a query Using a self join using ordernumber + 1 = ordernumber Then simply add where customernumber <> customernumber add a dummy column with the value 1 On this query build a new query self joining the above query On ordernumber <= ordernumber Group by order number, sum(dummy...

Three likely problems... well two actually "[tbl_BackLogWithLinkedWO]![WORK_ID]" > "[WORK_ID]" , no need to prefix the table name... neither so in the where cluase. And NO suggest a number, which doesnt require quotes in the string DLookups are usually a bad habit though, consider your...

Yes AD works (best) when within one local network... I know it can work cross network, but I wouldnt know how... I am not a dba or anything. You can design the queryies in access then take the sql and implement the sql in the excel like a pro, without bothering about the details. Sorry cant...

Simply import the file into a temp table, then append all records excluding the ones you dont want into a permenant table

what item did it import last? That is where it got stuck and your next item isnt a Mail item Perhaps some attachment, calander invite or some other sort that it cannot handle as a "MailItem"

In case you dont get it, that means... on average we dont use macro's ... We were all inexperienced at some point, there is no "pain" in asking questions. Knowing you have a lot to learn is already a lot better over many that think they are all that.

Sorry but if you dont know what to do with autonumbers and primary keys... what are you doing making a database? Sorry to be harsch but go back to your excel sheet or word document. Sigh. What you do is when ever you make a table, ie. tblOrders is make an ID field, ie. OrderID... this is always...

Duh, its your on timer event, it adds the record before the ordernr is entered.... WHY WHY on earth would you do such a timer? Net price is a calculated value, we dont store calculated values in proper database designs.

1) nice crypt digging, it is not common place to post on thread that is over 16 years old !!!! 2) in a proper database design we dont store calculated values

Using ORDER or your ORDERNR as a Primary and/or Foreign key is a big issue to start with. Meaningfull keys is a big NO NO. Suggest you change your keys to work on meaningless Autonumbers. There is probably some variable being used in the wrong order?! Can you upload the db?

Like "()%" left(field,2) = "()" len(field) <= 10 Just to offer a few ideas

Can it be that the record still is in "edit mode" on the form, which is why it looks wrong in the table?

I stand corrected :)

SQL server can be given privileges based on the Active directory user... this would auto-authenticate the user using your access or excel sheet. If the excel sheet is (ab)using the database only to get to the sql server data, skip it and run the query straight from excel to the sql server backend.

"backend on a server" could be a MS Access backend something else... on a server -to me- says "bigger database" like SQL or Oracle... but can be a mis-interpertation. many thousands of records, are not as many as it sounds... Slack like this can now a days be hidden by over performance. But can...

Well if your DB changed with it as well, perhaps you can use a relative filepath instead.

Problem with your solution @bastanu in this case is the OP is using a sql database. Using the forms solution forces access to evaluate the query at the client side instead of server side... generating a lot of overhead and a potential draw down on performance.

The % is the official notation for a space in the hyperlink File is because you are pointing to a file The link should still work? Have you tried the new link? Why do the replace in the first place?

best way to do this is to create a Pass through query to base your form on... and place the sql in it like arnelgp suggests. You can the requery the form which will fire the query on your sql database and display the record