Search results

I'm going to create a theatre database, but I'm having trouble creating the basic relationships of the tables. We have multiple shows and I want to be able to add shows in the future. Each show has a Cast and a Crew. Each Cast/Crew list is populated from a Contacts table (names, phone #'s...

One of my teachers is us having graphically add vectors. I choose not to use paper/pencil/protractor, but instead to draw them in Excel. The only problem is that Excel doesn't automatically size the charts appropriately. I can set the min/max for the x/y values to be the same range, but how do I...

When I put the cursor into the Combo Box then start typing a name, it sometimes says, Run time error '2001': You canceled the previous operation. The debugger then comes up highlighting the Me.Bookmark = rs.Bookmark line: The Combo Box's AfterUpdate() Dim rs As Object Set rs =...

People ----- Name Number Type Notes (1 to many relationship with People table, based off Number) ----- Number (lookup to People table) Note Date I need to take all people of a certain type whose newest note is more than 6 months old. Here's what I have so far (it doesn't take into account the...

Has it seemed to anyone else that the site is getting slower? Taking longer (possibly even freezing) when posting a reply or a new message, some forums not even loading the first time, etc.? Is it me and my connection or has everyone experienced these things?

The part that I'm a little lost on is the WHERE part: Table1 ----- UniquePersonNumber blah yadda GruntSounds ----- ooga booga blargh HowSpeak (1 to many relationship with Table1) ----- UniqueNumber (lookup to UniquePersonNumber field in Table1) Sounds (lookup to GruntSounds table) The part...

Dim junkVar as String junkVar = Nz(Me.Names_Combo_Box.ListCount) The above code sets up a combo box's slider nicely. Otherwise, the slider is really jumpy and can only slide short distances. I have a query that is the basis for a subform of a subform. The query pulls information from a main...

Is it possible to change the record numbers displayed at the bottom of a form? For instance, rather than 1-10, make it display 14-23?

SELECT * FROM [aTable] WHERE [aTable].[aField] <> 'thing' The query is returning most of the results where [aField] is not equal to 'thing'. But, it's also not returning results where [aField] IS NULL. Doesn't this mean that the query is thinking that "thing" = IS NULL?

How do I tell which row was last selected in some record? I see that, when looking at a table/form based on a table/subform based on a query/etc., there is a black arrowhead next to the last row that had focus. How do I tell which one this is? And, more importantly, how do I reference...

StudentInfo ----- StudentNum StudentName etc. InstructorInfo ----- InstructorNum InstructorName etc. ClassInfo ----- StudentNum (related from StudentInfo) Name Grade StartDate EndDate Classes ----- InstructorNum (related from InstructorInfo) Name StartDate EndDateClasses will have rather...

I have a form based off my main table -- each record has its own number. If a person attempts to add a new record that has the same number as another record, normally Access just pops up the message noting that and stops the update. I'd like it to check such as soon as the person is done...

I have a list of people, all with types: Qual <-Lowest Pre A Pre B Pre C <-Highest "Pre *" is the highest, Qual is the lowest ranking. I'd like a SQL statement to to Order By: Reverse alphabetical order if it starts with a P, then alphabetical order for the rest. Something like this: ORDER BY...

Can more complex statements be put in Replace()? For instance, say: replace all / or . with ^ in someString or replace 67 with 59 in someString unless there's a 4 after the seven replace 67 with 59 unless it's 674, then don't touch it replace 67[!4] with 59?

.property = string1 & string2 If one string is null, does an error occur? Do I have to write that as: .property = Nz(string1) & Nz(string2) How can I instantiate a string variable and set its value at the same time? Like: Dim someString as String = NullString or "" or whatever

In the startup screen, it would check for the employee name (Windows Uer Name) and adds it to a table if it's not there. The table is the basis for a combo box which can be set to list which employee has a given person. How do I use an Insert statement? I'd like to do somehthing like the...

Which is faster? Different parts are embedded in a Select Case or an If loop so I can't say "theString = "beginning middle ending".Dim stringBeginning as String Dim stringMiddle as String Dim stringEnding as String stringBeginning = "beginning part" stringMiddle = "middle part" stringEnd = "end...

In VB code, I build a SQL statment. I then set the RowSource of a Combo Box to that SQL statement. My code doesn't seem to be adding the final clause to the WHERE statment: AND [App Info].[App Type] <> 'Canceled/Terminated' You see, I thought I'd put in an unbound checkbox on the form and...

I have an Excel file that has checkboxes in it. When I look at the cell, it shows a letter "c" in it. Just a c. I'd like to add a script that replaces the empty box and puts in a checked (x'd) box. How do I enter a checkbox into a square, empty or checked?

I have an Excel sheet that I'd like to bring into an Access Form -- populate the Excel cells with data from textboxes on the Access Form and print it. I tried copy/pasting various things in, but it's pasting even text from a cell as an Excel object (let alone joined cells and images). Where...