Search results

How many tables do you have? What do tyou append to? SHow your data structure. Forget creating complex composite keys. That will bite you. If you have an order and order lines, then you should have a shipment and shipment lines. Each shipment line will correspond to an order line. More than...

1. What is RBAC ? DO not use abbreviations! 2. To be honest, your request is full of details that are difficult to fathom at this stage, and it is not supported by any graphic which might have rendered it more digestible. Make a sketch 3. Your narrative gets lost in some happy mix of minutiae...

This is just like people all living in towns having streets of the same name. So you have someone at 2, Highstreet, Town1, and someone else at 37, Highstreet, Town2 etc. The full address is City, Street, StreetNumber. Then you could have a postal code, function-wise an autonumber for each...

No you don't need to create columns containing data in their names - that's Excel. This is Access. Here you write records. In this way your data grows vertically and does not require any changes in forms or reports. You can display it like you want using crosstab queries or excel.

This example shows two things: 1. How to set parameters for a stored query (useful for example when exporting query with specific data) 2. How to use a such stored query as recordset for a listbox or combobox.

As an aside, concerning : Set A= dbs.OpenRecordset("A", DB_OPEN_TABLE) 1. Not a good idea to specify dbOpenTable if you ever split your db. dbOpenDynaset is better (unless you use and intend to keep using the .Seek method) 2. This parameter is normally dbOpenTable, not DB_OPEN_TABLE. Did you...

For selecting a bunch from a table you have a number of options: 1. You can make a new table in which you store the selected ID's in one column and ID for who did the selection in 2nd column (in case of a multiuser db). You delete the selection and make a new one each time. 2. You can use a...

You really should hone your google skills - that is worth a lot of code and time, instead off running to AWF with a question you could google yourself in 60 seconds. Use AWF for less obvious things. Where did you get the idea of using objMailItem in objOutlook.CreateMailItem(objMailItem) ? This...

Norwegian alphabet is probably the culprit. The sql is confused about when an aa is one letter (å), and when it is a literal aa. If you tell it to use English then the confusion will go away, presumably. Read about database sort order and how to change it here...

Define "In Microsoft Outlook if the email does not successfully reach the recipient " If you bungled the addressing, some servers will respond saying no one of that name here. Many sysmanagers do not allow this, since this implicitly verifies emails for spammers. As to a positive...

Show your data structure - take screenshot of relations window with all tables expanded fully, and you may have to zip the screenshots to attach them here

Don't show a snippet but entire code -also the code declaring and opening the record set. Also, "Name" is a reserved word and as field name will get you into deep doodoo sooner or later. Google access reserved words.

define "generate table with random name" and its use by example

1. Use blank lines and spacing to make your big black blob readable for others. If you do that I might read it. 2. Me.txtsDate = "" is not valid if that control contains dates - you cannot put a date equal zero-length string as "". Use Null. 3. What error do you get - do not keep the error...

"Happens to you when you die".... For reasons unknown, this reminds me of an interview I once saw, ages ago, obviously, with the late Dr. Kevorkian (you might want to google him, if you do not recognize the name). He was asked "What happens when you die?" and his answer was "You rot" :D

1. Use line breaks and spacing to make your stuff readable for others but yourself 2. Your data structure sounds wrong. Orders usually have some common data called Orderdata in additions to OrderLInes (or items) , and that is where one might save common customer data (like shipping address)...

Hmm ... and the other religious freak meant we all just strayed from the one true faith (a rather different one, though, from the first religious freak's one and only and true faith) and I'm sure somewhere there were trials and tribulations scheduled for all of us who fail to return to the fold...

Did you check this in the backend DB? Update: And BTW, deleting is seldom done in a db, to avoid mistakes and also because you can run all kinds of useful statistics. Normally an order would just get flagged, to remove it from normal daily run of things, not deleted (because deletions also...

Interesting stuff -especially when you encounter it within yourself but also others. In fact easier to spot it on others: I'm watching, daily, a near-suicidal behaviour (businesswise only, fortunately - this concerns increasing sales on a website that did well once upon a time, but no longer)...

I'll have a think again. Transactions do seem an obvious thing, but cease to be, when you consider having a parent form and child subform, and all the hoops presented to the user. I mucked about with this for days, taking off form Galaxiom's transacted bound form (somewhere here in the forum -...