Search results

I have a report which is formated into 3 columns, very similar to address labels (though they are not) for some strange reason every now and again it seems to lose its format and reverts to having all the information down one side, I then have to go back into page set up and reset it all. I have...

I am using the following code to transfer text Private Sub cmdImportSerials_Click() DoCmd.TransferText acImportFixed, "ImportSerial", "tblSerialNumber", Application.CurrentProject.Path & "\serial.txt", False Me.Refresh End Sub This works fine, the code is executed via a button on a form and...

When I set my form to open using a criteria, (acaddnew for example) I find that whenever I tab out of the first field in the subform it throws focus back to the first field of the first record, regardless of how many records are in subform. The subform is set to Continous and the first field is...

I have seen an example of this on this forum... I am sure it was not a dream...I have searched for 2 hours now, both on here and www but can not find what I want, maybe I am having a bad search day. :confused: A simple listbox with a textbox on it, that moves to the closest matching record in...

I have just put something together for my wife, a fairly simple db to show and record her family tree. It works very well (so far) for what we need. The actual family tree is viewed using the ms tree control. I know the this component does not support a print property however does anyone know a...

I am using rst.FindFirst rst.NoMatch rst.FindLast in a procedure and they throwing back "Data/Method not found" is this because I don't have the correct reference? This is the full code Tree Control TIA

The company I work for are thinking of applying to become a public bonded (customs) warehouse. Have any of you had any experience in building an inventory system that will confirm to the requirments of UK Customs for the managment of items within a bonded warehouse with Access? I think I am...

Is there away of ensuring that when a record on a form is deleted any child in a relationship with it on a sub form is deleted? Thanks in advance

I have a customers form that opens (datasheet view) allowing a user to choose a customer - on this form there is a button to add a new customer via a another pop up form. When this (add new) pop up form closes, it requerys the customer form, showing the new customer in the list, which is...

I am using this code in the on exit of a field on my subform, Private Sub Quantity_Exit(Cancel As Integer) Dim intQty As Integer intQty = Quantity If intQty > 0 Then Quantity = -Quantity End If End Sub Works fine, however if the Qty is >0 then I have hit Tab twice to move to the...

I am probably missing the obvious here but it something that has me really stumped. Any Help would be appreciated. I have a form with a linked subform. I need a way of when I add a new record the record is created automatically. What happens at the moment is the user can by pass any of the...

When is it proper to trap for errors, is it a good habit to trap for errors in every procedure or is it not needed. Can anyone explain error trapping a little more to me, it's something I have not really dealt with before. Thanks in advance.

I made some changes to a database I use in work while at home this weekend. Everything worked fine at Home but when I use the DB in work I am getting an error in the code I added. Here is the code: Private Sub Form_Load() Dim intResponse As Integer If DCount("SumOfQty", "qryPickLocation") < 1...

I don't use VBA a lot and was wondering if anyone could tell me why I can not see all my Forms in the object browser window. Thanks in advance.

Hi all I have a subform within a form, on update of the first field (location) a subdata sheet automatically expands to show product and qty stored within the location entered.... All this works fine, however after entering about 4 records, the subdata sheet becomes hidden below the window of...

Can anyone please help me with a small problem I have? On my report I have a list of Pallets numbers, I am using =Count([Pallet]) to show the total number of pallets on the report, however occassionaly their are duplicate pallet numbers on the report (requirred). Is there a way of ignoring...

Hi Is it possible to set the property of a subform to expand when a user tabs out of a field? Carn't seem to get it to work. I can set the subform to be expanded as default but I don't want this. Thanks

I will try and explain my problem as clearly as possible and hope that one of you are able to help. I have a simple db that is used for stock control purposes. The stock itself is held physically in different locations. The stock items are put into the database via a form with the fields [Item]...

Is this possible, because I just carn't seem to get it to work. I want to set the criteria on the result of part of query, that throws up a msg box if the result is <0 (a minus). Everything I have tried does not seem to work, can anyone help please?