Search results

Hi Forum, I'm building a db to track computer and user problems for work, where I double as a Client Support Administrator (IT Guy). I have these tables: (simplified list) tblComputers tblPeople tblCompAssignment tblProblems I'm at a loss as to how to link the 'Problems' table. This is...

I have searched high and low for this: How can I get FileDialog to open with "My Computer" selected? When I tested to see what the InitialFileName property of the FileDialog is with My Computer selected, it comes out as "My Computer\"...but setting that as the InitialFileName property is...

Looking for thoughts/inspiration on this: -Currently designing a process mgt app. -Process flow is pre-defined, but subject to change. -Flow consists of milestones with cumulative workday suspenses. -Some milestones are subsets of other over-arching milestones. -The project will flow according...

Hello All, In my table, I have some records that are duplicated (aside from the primary key). How can I select only one record from each set of duplicated entries? (There may be more than 2 of each of the duplicated records, but I only need to pull one of them...doesn't matter which one.)...

In my DetailsView, when there is no matching record, I want to switch it to Insert Mode. I have tried If Me.DetailsView1.Rows.Count = 0 Then Me.DetailsView1.DefaultMode = DetailsViewMode.Insert Else Me.DetailsView1.DefaultMode = DetailsViewMode.ReadOnly End If but that doesn't work...

My details view shows current job position by linking a person to a position in a bridging table called tblPositionFill. The fields in that table are: PositionFillID (PK) PositionID (FK) PersID (FK) FromDate (DateTime) ToDate (DateTime) What I would like to do is either: 1. Prevent user from...

Using VWD 2005 Express (2.0 framework)... I need to get a querystring from the URL as the value for a field in the INSERT Command. So far, I'm stuck. Any suggestions?

Refresh my memory, what's the setup secret in IIS (or wherever) to get Access to cooperate with Dreamweaver (or anything)? I make my connection string via the old .udl file trick, click 'test connection' and it tests good, but when I try to create a recordset...I get ***no tables***. When I...

My "Organization" page has a datalist control that lists the sections in my organization (from a database). I plan to build a hyperlink into each section title that will open a staffdirectory.aspx page that will list the employees and contact info. The link will be like...

I'm trying to get acquainted to .NET (2.0), using VWD Express 2005. It's not obvious how you'd go about adding a new record. Like I'm looking at my GridView, and a particular person is not loaded...how do I get from there to looking at the GridView with the new person listed in it? Kodo...

I know that this is not what μSoft had in mind when they thought up Access, but... I'm building a "Texas Hold'Em" game in Access. Got most things to work OK, but am stuck on the betting rotation. You have to pass the bet around, so my main "Play" form has fields "Bet" and "Pot" which are...

In the course of building a Texas Hold'Em game in Access, I had a hard time finding any code samples for scoring poker hands. Here is what I came up with... (Please ring in with any suggestions, as I am still developing the application) '*********** 'Purpose: Score poker hand 'Inputs...

Hi All, I have a table where the field names will naturally change over time. They are related to fiscal quarters, with boolean values in each row. The changing field names have to be in response to what's available in my import file (XL), which is used to update the table via an append...

Hi Everyone, I will figure this out, but I thought asking here might help me simplify the method... I am building a new db to track the flow of documents for our Command section. The boss wants the following metrics to be availlable on a regular basis: - How many documents (out of how many...

Hi All, I know this is a silly question, but here goes... I have just been handed a second database that was designed with macros (objects) used throughout. My mission in both cases was just to make some minor changes to the database, but I just can't help but want to rebuild them and do away...

I have read a lot and learned a lot here about ACCESS. A big THANKS goes out to all of you. I am writing to you from Okinawa, with a problem that my (military) Work Group Managers cannot help me with... I have recently had my workstation reformatted, and right after, I couldn't open my...

Hello Everyone, I have been eaves-dropping on your Q&A for a couple of weeks now. This place is just so full of information...I'd like to thank you all for just being here. Now the question... I have been tasked (I reluctantly raised my hand at a meeting) with building an Access database for my...