Search results

Thanks alot Paul. I got it to work. The problem I'm having now is that I want to display the country which the employee lives in. The country is on another table, which has the composite PK of City and Zip Code. So in my control source I'd need two values, the city and zip code. I'm having...

Okay, so I went to the row source for the combo box, opened the query builder, and then changed it to SQL View, and Changed this: SELECT Employees.EmployeeID, Employees.FirstName, Employees.LastName FROM Employees; To this: SELECT Employees.EmployeeID, Employees.FirstName & " " &...

Thanks a lot Paul. That works fine. The only problem is that the employee name is in two fields(first & last), so when the combo box is up, it only displays the first name(1st column), but when you click the arrow, both columns display. It's not really a big deal, but if you know of a way for...

I'm currently working on an employee data form, and one of the text boxes is "reports to", which shows the employee ID of who the employee reports to (Their supervisor). The problem is I want this to display the supervisor's name instead of their employee ID. How should I go about doing this...

missing I know exactly what your saying. But if I opened the form and closed it right away it actually creates a record in the table "ProductOperations", not just in the subtable like your saying. I tried showing this with the screenshots, but I guess that didn't work.

I did this and it fixed my original problem. But it doesn't fill in the default fields like I originally wanted. Here is my code now Option Compare Database Private Sub done_Click() DoCmd.Close End Sub Private Sub Form_BeforeUpdate(Cancel As Integer) If Me.NewRecord Then If...

Thanks a lot for the help guys. I'm having another problem now. If you open the form and don't input any data into it and simply close it, then it creates a record with the stepID (PK) and the step# with no other information. I don't want it to do this, and it creates a problem because there...

Hello, I currently have a form where I'd like the default value for one of the textboxes to be the maximum value in a field + 1. Basically, I want my primary key field to increase by 1 each time a record is inputted, just like the autonumber field would do. All I need is the vb code to put in...

I'm not sure what I could've done differently...it says on the status bar to stop the operation hit "ctrl+break" so after 10 minutes I did this...it wouldn't allow me to do anything on my computer, even browse to different windows or view my desktop...Next time should I wait longer? Just sucks...

there's no way to access any of the records? even in just one of the tables? :mad::mad::mad::mad::mad: ...this sucks.

Hi, I have a database with approximately 1300 records in it, which I encrypted with a password while I was working on it(by simply clicking decrypt on the database tools ribbon and putting in the password). I presented the database to my boss and he asked me to take the password off so I opened...

Yeah, working with access isn't something I normally do (obviously). I'll attach a screen shot to help explain what I'm trying to accomplish. Thanks for the help by the way. All I'd like is for the bar at the bottom of the subtables(at the right and bottom of my screenshot) to disappear. It...

I fixed my original problem, but the solution gemma suggested for eliminating the navigation bar at the bottom of my table cannot be done. Let me explain what the form I'm working on currently has on it. I've got a combo box which filters the results in a table which has been imported into...

In case someone else has this problem. I found this solution on another board. Thanks to imagirlgeek at comp.databases.ms-access: First, log on as a new Windows user to the computer to see if you have the same problem. If you can open Property Sheets as the new user, export the following...

I just did this (it took a few minutes because it's a big db) and nothing was fixed. Any other suggestions? I tried the suggestion by gemma also and this did not work. (I went to VB clicked insert module and put that code in there...I tried this immediately after I noticed the error also and it...

Hi all, I'm having a serious problem with my database. I put some code into the even properties for a form to try to disable the record navigation menu at the bottom of a subtable within the form, and now I cannot view the property sheet in any of the forms/tables/queries in my database. Can...

Another idea...could I create another combo box at the bottom of the form where the use selects the StepId and then hits enter and the details for that step would display either below or in a new window? Please any help would be great...I'm stuck and I need to get this to work...other ideas...

haha, no problem. Right now I just have a filtered table. The afterupdate code is as follows : Sub CboPartNo_AfterUpdate() Dim rs As DAO.Recordset If Not IsNull(Me.cboPartNo) Then 'Save before move. If Me.Dirty Then Me.Dirty = False End If...

Hi all, I have just created a search form which when you type in a part number, it displays the part information, as well as steps required to create that part. My boss would also like the user of the search form to be able to click on the specific step (StepID) and view information on that...

Hi All, I've searched a few times, because I didn't want to post a repeated thread, but I can't seem to find what I'm looking for. Here is a little background on my database so you can get a better understanding of what I'm having problems with: I currently have a database (Access 07) of...