Search results

Hi There, i have got a running total on a datasheet subform, im trying to change which totals to show or hide. When i make changes it keeps reverting back to my original setup. I have tried everything saving re opening and closing the database. But what ever i do it will not save the change i...

Thank you James! with some tiny adjustment it works a treat thank you! Private Sub Cost_AfterUpdate() If Not IsNull(Me.Cost) And IsNull(Me.Qty) Then Me.Qty = 1 End If End Sub

Hi There I need a little help figuring out how to do something, i've got a datasheet form for filling out an order which has both quantity and cost. What i want is if they skip typing in the quantity and type in the cost, then it will automatically fill in the quantity as 1. but only if the...

I though Dlookup might be the one, can you use it in a textbox property or will i have to use vba? I need the PK as i keep getting the message you cannot add or change a record because a related record is required in table 'tblCompany'

Hi There I have an unbound textbox in a form which is filled with a text value eg "RWL" when the form opens. I now need another textbox that goes to the Company Data base finds the "RWL" text and finds its Primary key and puts it in the new textbox? whats the best way to do this?

Yep i've managed to make it Unique now by adding RWL or RFW at the start of the code. Ive created a query on the new table, and now managed to set a Primary! If i want to refresh do i need to delete the table and re import via VBA? if so does that mean i have to set the primary key for the...

nope it dosnt which is the main issue, as some of the Account Id's conflict

Firstly i have 4 supplier tables with identical field names but different databases in sql. I want to have them all in one table and only want the information for reference i do not want to edit any of the data. I need to create a new primary key number for the complete table. The data will...

If i delete the data and say 3 new items have been updated. i may get the issue that the primary key ID numbers have changed which will effect data already saved in other tables?

Hi There I'm trying to create an access table (with a Primary key) that loads in the data from a Union SQL view. Im hoping there is a way of achieving this? Ive tried an append and create table queries which copies the data but still no primary key. I've created a blank table with the fields...

Hi thank you for your reply, sounds like a perfect solution. Im pretty new to access how would i go about setting it up? Set up the data fields? But i need the linked information to refresh also? thanks

Hi there i have a Union SQL view for an external data source, when its imported into access all the data types revert to Short text and i have no primary key. I understand you cannot edit linked tables but any ideas how i get firstly the SQL view to import with the correct data types and...

This has been resolved, after a bit of playing with format it was due to the border style. It was previously set on Thin, But Size able seems to do the trick. Hopefully this will help anyone who comes across a similar error!

Hi there When going from one form to another my form dose not seem to paint the background color all the way to the edge, seems to be un even gaps around the edge? (see photo) has any one else had a similar issue? and is there a way of stopping it? It isnt a major issue, but its slightly...

This has been resolved it was due to having the query linked to my form, i have now taken the form rowsource away and filter the query only.

Hi There I am using the Filtering a listbox method from this post http://www.access-programmers.co.uk/forums/showthread.php?t=188663 It works great apart from when i type too many characters and no search results can be found i get a run time error '2105' you cant go to the specific record...

Sorry to bump, has anybody got any ideas please? thanks

Hi the if statement is for selecting the end of the data in the text box, so its constantly updating the listbox after each key press? Is this what is also causing the error? thanks

Hi there i have got the bellow code that filters a listbox which is based on a query, from a textbox. The code works fine and it Filters, but if i put in too many characters that do not exsit in the data( so it cant display any results) i get an error saying Run time error 2105 - You cant go...

Hi there im after trying to make an image on a splash screen rotate around on its centre as a loading icon? Im guessing i will need a loop on the form opening? any ideas thanks!!