Search results

This forum and its members have been providing me with solutions for 13 years now, I need a few lifetimes of posting on here to give back what I owe :)

If you are updating the checkboxes live, you will need to requery your subform everytime an update is made to show the updated ticked rows only

I'm incorporating a Cheque Printer into my application. The user wanted a more use friendly interface to move fields (Beneficiary, Date, Amount, Amount in Words) depending on the cheque formatting from that bank. My initial solution involved a traditional text box at first wherein the user just...

This is exactly what I was missing - the initialize bit. Thanks a ton MajP. I actually always wanted to practice Class Modules and figured this would be a good time to do so. Follow up question if I may: triggering these 3 mouse events now calls the code in your class module bypassing any code...

The user wants to be able to move labels on the form whose positions are linked to a report

Hello All, I have a form wherein I'd like to drag and drop multiple labels, I was able to do this for one label and figured there must be some sort of technique wherein I wouldn't have to re-write the code for every single label. A little research pointed me towards class modules and I ended up...

You're an absolute lifesaver jdraw - I spent the past half hour searching for a solution for this and all I came across was CurrentProject.AllForms(FormName).IsLoaded which kept returning debug errors if the form wasn't loaded, thanks jdraw

You can do it with Access 2013: http://msdn.microsoft.com/en-us/library/office/jj249372.aspx I am yet to try it.

Can you upload it in 2007 format or even mdb please? I have a feeling it's a query issue but nothing that can't be fixed :)

Hello Mark, You sure it's not type = 6? On my accdb all my tables are type 6 for some reason. Cheers, Sam

I know it's an old thread but in case you're still looking for an answer here's something that may help. I used both DAO and SQL. What this does is duplicate all the records in subquote for a certain a quote. Dim tempQuoteID As Integer, tb As DAO.Recordset tempQuoteID = Nz(DMax("QuoteID"...

35 queries and 25 reports for your DVD collection!! Wow! Now I'm really curious to see what you did there! If you don't mind sharing it here we'll definitely have a look at it and see how to improve it

Welcome aboard Erica! Out of curiosity, what is it this database of yours does that helps you with anger management? :p

Is the purchase order number a string or an integer? If it's a string then you need to add single quotes around it strWhere = "PurchaseOrderNo = '" & strpono & "'"

Thanks Pat, I figured that was the only way to go with it, is it good practice though? Thanks for your offer Gemma, but I'm not really looking into something that deep. Just recording payments and income from hair services.

Thanks for your help Pat. Another issue I foresee running into would be when reporting transactions as depending on the transaction type, the linked table should vary to retrieve payee's info. For example, if a transaction is a salary payment, it should link to employee's table to retrieve...

Hello All, So part of a DB I'm building for a Salon requires a little income & expenditure reporting. The income from every hair service needs to be recorded, as well as daily & monthly expenses (rent, salaries etc..), some payments are made by cash others by cheque/credit card. My question...

Are the queries on your backend or frontend?

The attached file is corrupted sir

Also, you can setup a table with user permissions and check for user permissions upon opening a form to show/hide whatever options you want. PS: Go Liverpool!