Search results

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

1) whats wrong with your enter key? What a wall of text! 2) whats wrong with your language, does it really hurt to type proper english? 3) whats wrong with your space key? Indenting code is KEY to keeping it readable! That beeing said... to find the max ID you dont dont have to use a loop with...

still DLookup for conditional formatting feels like the excel way of using a vlookup, which is just plain wrong. AND why on EARTH would you want to add two values that are part of your where clause.... the sum of the two values should only return 1 value.... This seems redonculous!