Search results

I think lagbolt was wondering, if textfiles can be imported from the network, then why can't the new front-end just be put on the network and they replace their current one. That's how I took it anyway.

It's the control where your user is entering the plate. I assumed it was a control on a form. If not, how are they entering the plate name?

In your code... instead of opening the entire table as the recordset, define the sql above it and open it that way.

Bob is absolutely correct. I just like filtering in code because you may want to filter by something else at some point.

Can you adapt the following: Dim strSQL As String strSQL = "SELECT * FROM qryExportToExcel WHERE PlateName='" & TextBox & "';" Set RST = CurrentDb.OpenRecordset(strSQL, dbOpenDynaset) Of course, replacing PlateName with your field and textbox with your control name.

What would you like to filter?

Maybe I'm Missing it, but I don't see strTQName Dimensioned or passed a table name. You have to assign the name of the table to it. EDIT: My mistake. I see it now. My browser was screwing up again. lol! Sorry. Does the query qryExportToExcel contain any data? Also, you have to define a set...

Thanks for the understanding, RX. There is no security yet, if I understand the question correctly. I'm new to Access, so I don't quite understand everything yet. In the beginning, there will bw 5 to 10 users. As it expands, there could be well over 100. Citrix is a no-go for me. The people...

Where I work, I can not send Access files via e-mail. The place is two miles wide and everyone works different shifts; nights, days, etc. It will be physically impossible for me to install new front-ends on each users computer. Therefore, I have come up with this method... As I make additions...

You're very welcome. Glad it was useful.

Thanks. That is what I intend to do, but the landscape here makes issuing new front-ends to each user virtually impossible. The idea is to keep the text file folder on the network. This way, everyone has an updated version every time they use it.

In design view... right-click on the button, select "Build Event" then "Code Builder". This will bring up the code module of the form and should already be in the click event (Private sub Commnd_Click) Place the code between the the private sub line and the end sub line.

Add similar to the following to the button's click event: Private Sub Command0_Click() If MsgBox("Save changes?", vbYesNo, "Title Here") = vbNo Then Exit Sub Else 'Your stuff here End If

At what point do you want your message box? When closing the form?

Good news. I'm glad you got it working.

Can you post more of your code, especially how you're determining the value for Rev?

Try a DELETE statement instead... Dim dSQL as string dSQL="DELETE * FROM yourtable WHERE Revno >'" & Rev & "';" Currentdb.Execute dSQL

Hello all! I'm in the midst of building a fairly extensive database for my company. I've split into front end and back end, but I've become concerned about the front end bloating as well as updating the front end as constant changes and additions will be required. In other words, forms...

Hello all! Though I have been programming with Excel for several years, I am new to Access. I've always resisted Access because I love Excel. However, a new project has been assigned to me that I must use Access for. To be honest, I wish I had made the switch sooner as I have become addicted...