Search results

Is it possible in Access SQL to concatenate a control into the select statements table or fields? Such as: SELECT fldtotal & [Forms]![frmTest]![lstYears] & fiscal FROM tblTotals & [Forms]![frmTest]![lstYears] & Archived The statement would normally be: SELECT fldtotal2003fiscal FROM...

The Doc's right. Its not so much that its complicated but when all lumped together it can be. You will more than likely end up doing SQL queries with the Like operator based off of the text box entry. Give some more info and hopefully someone can get you going in the right direction.

The_Doc_Man is king in my opinion on networking DB's. But I would look into you network shared folder and make sure everyone has read/write/create/delete/modify rights to the folder and it is setup as a shared folder. As access has to create the .ldb file. Also, make sure in you options when...

In the after_update event property for the combo box, put something like this: If me!combobox = "Microwave" then Me.TextBox1.Visible = true Me.TextBox2.Visible = true Me.TextBox3.Visible = false etc.. elseif me!combobox = "iDirect" then Me.TextBox3.Visible = true Me.TextBox1.Visible = false...

I don't know why you're having some problems. So I will just give you the general steps. If for some reason the linked table manager isn't working from the front-end...delete all of your tables (backup so as not to lose data.) The click file - get external data - link tables. Navigate to...

Good point Pat. Once again all knowing. One funny thing though..I have tried for years to get my $%&^#$%^ users to just type the last two digits of the year if in the current century and I can't get them to accept it. For most of them they are set in typing /, full years, and all sorts of...

To modify a record use: UPDATE table SET record = whatever WHERE record = the textboxes; Do a search for SQL commands and you will find tons of info regarding this. If you need more info. just reply with some infomation about your form and table structure, etc. and I will see what I can do...

OK I went and played with this a little bit. The only way I could get it to work was to do this. Burn to cd the excel file. Then open the database from your hard drive and link the file via file - get external data - link LINKING the file on the cd. Now save the db and burn both the DB and...

When you originally linked the file it had a full path i.e. c:\user\file.xls so when you burned it all to a cd and are running the DB from the cd (I think this is what you are doing) it is looking for the file at the full path and not the path as related to the cd. If this makes any sense...

Use a filter or where clause in your open statement. Try something like this: DoCmd.OpenReport "ReportName", acPreview, , "[Fieldname] = """ & Me.[Fieldname] & """" Hope this helps.

Did you import or link your tables? If you imported your tables, then you no longer have a FE/BE.

Most of us could probably use a little more data. i.e. table structure, form structure, relationships, and exactly what needs to go where. But overall, I would say that you will probably end up using SQL statements to modify the tables you want. Probably, this might be a little inefficient...

I had the exact same thing happen today on a db that has been running fine for over a year. The problem occured when the user clicked on a text box to open a new form. I found out that one record in the table had become corrupted. Any time I tried to view the table in spreadsheet view and...

I agree. If you properly index the appropriate related fields then the autonumber is really insignificant. I have however had to create a multiple table auto-increment system to track purchases on different cards/different card holders. I finally got the bugs worked out. That is the only...

Yes that is true, but I use the input mask on dates because the user doesn't have to type "/" and they see the format. Since I use short date for the format on the text box on a form and I use an input mask as well, I force the user to not only see the format but make sure it is input as well...

An input mask on a form "masks" what is typed in to the appropriate format. If the mask is on the table alone then when a user attempts to update and doesn't know the appropriate format they get an error. In my opinion, if you want a specific format only, then put a mask at both locations...

I do all of that with my network. I make mde's that reside in a shared folder for most of my users. I have a couple of FE's that reside in different folders for power users who know what they are doing. The biggest issue is rights to the folders. I operate on a novell network and just created...

Open the database exclusively then click tools - database utilities - compact and repair database.

On a continous form I have a button with the on click event tied to VB. The code is this: DoCmd.RunSQL "UPDATE [Fleet Assignment], fromPDA SET [Fleet Assignment].sup = 'C:\Program Files\PTS\TracerPlus 2.2\Data\YVTS\FromPDA\Signatures' & [frompda].[sup]WHERE ((([Fleet...

Pat, I have a continous form where the control source is set to one table (through query.) It is completely different than the table that I am updating. There is only one common field between the two tables. Unfortunately, I have no way to relate the two tables by any key. On the form, if...