Microsoft Access / VBA Forum

Been reading the ongoing saga for a while now. Well actually I have NOT been reading it. I ignore most of it but get fooled once in a while into opening one of 'those' threads. Anyway the point of this is that I have a frind who works for a certain federal agency that is referred to as a bureau and does investigations... If you ever need...

From time to time, I randomly receive "Can't updated, Currently locked" error 3218 or 3246 from the following code in one of my form with pessimistic lock for 70 users environment. Any problem with the code? Private Sub Save_Record_Click() Dim stSQL As String Dim rs As Object Set rs = CreateObject("ADODB.Recordset")

Hi, I'm just in the development and planning stages of a new MDB. I would like to require the person opening the database either login or supply there name so if they make a change to table that there name would be recorded on the transaction. Does anyone have an examples of this process or could you please offer your thoughts on this...

test _________________________________________ Usenet Zone Free Binaries Usenet Server More than 120,000 groups Unlimited download http://www.usenetzone.com to open account

I am having trouble running a query. I select the fields I want to show up in the query, but they show up along with the rest of the fields. What am I doing wrong?

I am trying to build a room reservation system for our church. The problem is, some events happen on a weekly basis, other adhocs. What is the best way inquire for data and then display them? i.e. I don't want to ask users to enter the recurrent event every week in a year, is there a way to build a select... The tough part is, if one week...

I set the input mask for the date field to "00/00/00;0_" but instead of showing a 6 digit date such as 01/01/06, I receive 01/01/2006 an 8 digit date! Is there a manner in which I can over ride this?...In the table containing this date field? Or by way of the textbox control in which the date is entered on my subform? Thanks!,

Put 2 tables in a qbe grid & link 'em so as to list only records in tblA that have related records in tblB. Run the query. HiLite a row. Press delete key. A record is deleted. How can you design the query so that you KNOW in advance which table a record will be deleted from.

HELP!!!! I have a form with a combo box to select "Staff ID" and a Calendar which puts the selected date into my "Date" field. These two fields are the criteria for my parameter query. This works fine!!! :) the problem is that i want to use the same query with 2 different forms...so i thought i could set the criteria as the name of the field...

Sorry if this shows up twice, I clicked on post but could not find the post....! I have a database which requires the batch import of customer contact information, print mailing labels for those customers whose date of first letter field is null, and update the date of first letter field when the mailing labels are printed, I already...

I've got three columns i'm working on: Time Start (Date and Time), Time End (Date and Time), Total Task Time (Short Time) I've got Total Task Time working correctly. Here is my query: SELECT Format(Sum(),"hh:mm:ss") FROM Task_LogTest; However, I manually added it up (I've got 4 test rows) and the query is returning a time that is off by...

Bob, You made this solution very simple. This line worked: Forms!MyForm.OrderBy = "Description DESC" Thank you for this tip very much! I appreciate your help. *** Sent via Developersdex http://www.developersdex.com ***

I have converted access 97 to access xp project and connect the table from my sql server 2000. my problem is that when i run my report it says "Invalid SQL Statement. Check the server filter on the form recordsource" now this is my recordsource in my report. SELECT Students.IDNo, & ", " & & " " & AS Name, Students.Address,...

Hi i have a table containing the following fields man_date type test wheremeas measured value 1/1/08 12:00:00 M1 Hardness Top 2.4 1/1/08 12:00:00 M1 Width Bot 4.5 1/1/08 12:00:00 ...

"Roger" <lesperancer@natpro.comwrote in message news:00233b23-e608-4c4c-80e8-64e6fdaf56f8@a1g2000hsb.googlegroups.com... Thanks for responding Roger. In the end I managed to re-gig the schema such that DLookup wasn't necessary so the problem has gone away. I've never been a great fan of DLookup so I'm a (relatively) happy chappie ... for...

I set the input mask for the date field to "00/00/00;0_" but instead of showing a 6 digit date such as 01/01/06, I receive 01/01/2006 an 8 digit date! Is there a manner in which I can over ride this?...In the table containing this date field? Or by way of the textbox control in which the date is entered on my subform? Thanks!,

I need to have a form filter from two differnt fields. First the user needs to be able to pick from a list of categories. Then the user needs to be able to choose a size from the results of the category. If i set the parameters in the query, then they can't choose from the list. This is what I came up with, but when you use the second...

On spam

Is it possible to limit the number of Subform records using MS Access 2003? That is, my end users want the capability of entering up to 12 records on their subform. Is that possible? Thanks!,

"Neil" <nospam@nospam.netдÈëÏûÏ¢ÐÂÎÅ:7Tquj.11650$Ej5.10391@newssvr29.news.prodigy.net...

Sorry, i meant that with that format it would only accept null values? Paul On Jul 24, 2:24*pm, "paulquinlan...@hotmail.com" <paulquinlan...@hotmail.comwrote:

Bruce, You were correct. I failed to use the caption property of the label. That worked this time, thank you. *** Sent via Developersdex http://www.developersdex.com ***

Hello,have a problem with the following site The site link is this http://szenvedelyes.extra.hu I cant make the video work, its stuck or something, should i download higher flash? Or whats the prob? Thanks for the help.

spam

"timmg" <tmillsgroninger@gmail.comwrote So, summing up, using macros will, undoubtedly, build strength of character and make you a better person. :-) At best, there are worse things than macros; hmm, or is that, at worse, there are better things than macros -- now that I've turned 70, I tend to be a little forgetful. :-) Not totally,...