Search results

You might have just made a typo that first time. I knew it would work :) If you look at the SQL in the working query you made, maybe that would help you see what it's doing :)

If your table you are making these changes in is named that, then you will need this: UPDATE [TH Inspection File] SET [TH Inspection File].[FR STM DR I A W] = "Y", [TH Inspection File].[FR STM DR COMM] = [TH Inspection File].[FR STM DR COMM] & "~" WHERE ((([TH Inspection File].[FR STM DR I A...

hmm...maybe just try tblInfo.[FR STM DR I A W] - take the []'s off of all the tblInfo. That really shouldn't matter at all though. Something isn't right - something is spelled wrong or something. I know that code will work as long as your table is called tblInfo and those are the correct...

Okay - if your tables have spaces, you'll need to do this: UPDATE tblInfo SET [tblInfo].[FR STM DR I A W] = "Y", [tblInfo].[FR STM DR COMM] = [tblInfo].[FR STM DR COMM] & "~" WHERE ((([tblInfo].[FR STM DR I A W])="GF")); Just go to queries and choose create a query in design view. When the...

If IsNull(Me.Check_Field) Try that.

In a module you could put: Global Const gcccFrontEnd = False Or = True if it is the Front End. However - why is there a form in your back end? The only thing in a back end should be data tables.

Yeah basically the docmd.gotorecord is the same as clicking that next record arrow on the navigation on the form. The form will take care of adding the record so no need to add it in code.

hmm....I didn't know you wanted to add it on to existing text. In that case: UPDATE tblInfo SET tblInfo.IAW = "Y", tblInfo.Comments = tblInfo.Comments & "~" WHERE (((tblInfo.IAW)="GF"));

Is it the only field you need to be added? Or are there multiple ones? If it's the only field, on a form with that field present you won't be able to add another record until you type something in the box. Though they could type and then delete. If you want, you can do the following. If...

I would like to setup a mail merge template in word and use Access to be able to use this template to print letters from a temporary table or from a query in Access. Ideally I would like Word to open in the background and automatically print out the records using the template - with no extra...

There is no need to use VBA to do this. You can do this simply by having a text box on the form bound to your mechanic name field on the table. In the table all you need to do is set that field to required and they won't be able to enter a blank record. Of course, you can handle that error...

We were just having a brain fart in here :P

Have you tried a compact/repair?

We have a SQL server, but due to corporate red tape I can't put this in it.

Okay I know that even with a password protected MDE, programs exist which can reconstruct the VBA. My question is that if I define a global constant in the code - can that be pulled out? The reason I am asking is that I am working on some encryption in order to store sensitive information in a...

The problem is that you are putting it in as the input mask. That's completely different, and I didn't even notice that's what you were doing originally. Your formatting the data as General Number, so it will remove any leading zeros. Remove the input mask and put 0000000 in the Format field...

You can run things in task scheduler and put a password in there which will work if the workstation is locked. If you are getting the standard login when you return the next day, then your computer is probably being rebooted by the server each night. This is likely to make sure that patches...

SQL = Structured Query Language Basically when you design a query - you're running a SQL statement on your data when you run the query. More basic info here: http://www.w3schools.com/sql/default.asp

No problem - maybe someone will be able to give you some advice on getting the older Access to place nice with the newer Outlook - but if that doesn't work at least this can be used in its place. There is more info on that site on a tool used to create attachments and such.

AGH! I had this problem at one point, and I didn't know about the Retreat event. I do now though, cool :) I ended up getting around the issue in another way...but it was more complex than needed.