Search results for query: *

I have an employee table tbl_Master that has a list of employees including their position number [PosNum]. Another field in the table identifies who they report to [RptToPosNum]. I am trying to query the "front-line" leaders aka: Employees who's direct reports do not have direct reports of...

Hi, I have summary information in Access 2000 that I wish to publish to our SP site. When I select the "Export to Windows SharePoint Services()" option it exports the information just fine (and i prefer this format over exporting it as .xls or .html formats). However, now that I have...

In creating a glossary I have tblTerm. A term might have one or more aliases that are also terms within the same table. For example: Term X = Aliases Y & Z Term Y = Aliases X & Z Term Z = Aliases X & Y Term A = No Alias Term B = Alias C Term C = Alias B My current table structure: tblTerm...

Hello! I’m looking for some direction. I believe that I’m doing “OK” on the relational data design, but am struggling with the syntax and details of the coding. I have the following tables created (see picture). Essencially, I want a simple form with two unbound text boxes, [txtBadgeScan]...

Hello, I’m pretty familiar with Access, but just not in a multi-user environment. Right now, there is only one terminal that the application is saved on, but I have three different users that can logon. I put the application within a shared folder for all users to access. I can access it...

Hi, I'm running windowsXP and have three different user logons on the same terminal. I placed the db in the shared folder so that whoever is logged-on can see/use particular access applications. However, the apps can only be accessed through my logon. If you are logged on as anyone else it...

I'm trying to decide which barcode symbology to go with for our warehouse. Ideally, i'd like to be able to label cases/containers with both the stock# as well as the quantity. Is that possible to code within one scan? If so, which symbology should i go with? Doesn't code128 support this...

Hi all, I'm looking for more information about barcoding and incorporating it into Access. I've searched through the Access forums in here and have learned quite a bit. However, i still have many fundimental questions about barcoding in general (i.e. which symbology would be best for my...

Hi, I have records of all my customers' email addresses. I want to export those records into a text file with all of the [email] fields combined and seperated by a ";" so that the text field can be copied and pasted into a mass email. Thanks ~Rob If we expect the unexpected, does that make...

I'm trying to set my form's 'Has Module' Property to no... but i can't find where to do that at. can someone point me in the right direction? ~Thanks! ~Rob If we expect the unexpected, does that make the unexpected... well, expected?

I have done something in my database and now anytime i try to access records from forms i get this error: "error accessing file. Network connection may have been lost" I can go into the tables and edit/add information, but i just can't do it in forms. Any suggestions as to why? ~Rob If we...

Hi! I've been using an Access 2000 application on my old machine running W98. I've now transfered the files over to a new machine running XP. However, now some of my code won't run. It gives me this error: Compile Error: Can't find project or library I looked it up in Help and it says it...

I just got a new computer and transfered my Access files over. On one of my forms i have the generic combo box which populates the form from the selection you make within the list. However, it produces a Compile Error when i select a row within the combo box stating: "Can't find object or...

I have tblProducts which lists products by their stock number StkNum and then has a sub field Sub which helps differentiate different colors of that product. To make it faster and reduce error, I would like the form to fill in the ItemDescription field with the same information as any previous...

I have Table [tblColors] which has a listing of colors available to items. Some items have more than one color to them. I want to be able to combine more than one color to a particular item in the [tblProducts] table into ONE TEXT STRING on a bound form. tblProducts Item# 453 tblColors...

This one SHOULD be easy, What is the one-word description for a field name which would determine if a product is sold by "Each", "Pair", or "Set"? I have racked my brain to think of a word to describe this field. Thanks! ~Rob If we expect the unexpected, does...

I'm creating a spiffy new db and am curious to know what fonts work best for your users. Thanks! ~Rob If we expect the unexpected, does that make the unexpected... well, expected?

I want to give my customers a discount when they purchase more. I have a pricing structure where after $800.00 they get 5% off of their purchase. This is easily calculated with the following function in the unbound text box [Discount] on Form.frmOrders =IIf([Subtotal]>800,0.05,0) The problem...

In a table of a few thousand entries, which is more efficient? -One text field with a field size of 50 OR -Two text fields with their sizes at 25 Or are both so close that it's not much of an issue? ~Rob If we expect the unexpected, does that make the unexpected... well, expected?

I have a form [frmEmployee] which has basic employee information. Within that form, a subform [sfTrain] which tracks various training courses the employee has participated in. Within this subform is a field [Hours] which keeps track of how many hours are completed for that particular...