Search results

I went back and looked again and I think you fixed my problem. I just have never seen access format data that way. It is perfect and I thought it was broke. I have never expanded a row height in an access table on forms yes. Lots of times in excel but never in access. excel and access...

I tried that and it shows fine and even looks good when I import the table but after import the shipping address only has a name in it no address. Thank You for trying.

I am trying to use an excel workbook in my access 2013 database. I like to use linked tables because I can update the excel workbook and the new data is available when I go into access. The problem is an address field in excel only imports the first line of a 3 line address field. I have...

I am no expert so not sure how to explain it. I am not storing the information. The look up form is needed to find the seller in the over 7000 records. ABC Seller for example Then I want to open the ticket form and have a new record that has ABC seller in the Seller name field. That will...

That looks like what I need. I am not sure where to put both codes? I made my lookup form a popup. After I find the seller I want I have a button that says "ADD Items to This Seller" I can make the button open a form with a new record no problem. Do I add the codes to the on load or on...

Hi everyone, I have this code Dim ID As Long ID = QuoteID DoCmd.GoToRecord , , acNewRec location = DLookup("location", "tblSeller", "QuoteID=" & ID) UserFK = DLookup("UserFK", "tblSeller", "QuoteID=" & ID) cmdClose.SetFocus works really well. It opens a new record...

I actually found a youtube video that explained this. I only added the +1 at end of code. Did not want to take credit like I know how to program code or anything. Thanks.

I figured it out. I just need to explain it here so thank You. Here is what I used. I created a button and added this code to on click event. Private Sub Command24_Click() Dim ID As Long ID = DMax("INoID", "tblInvNo") DoCmd.GoToRecord , , acNewRec InvNo = DLookup("InvNo", "tblInvNo"...

I have done this before and I cannot remember what I did. I used a DLOOKUP and grabbed the number in previous record field InvNo and added 1 to it. So if last record InvNo was 14750 then in new record InvNo was defaulted to 14751 I can use this code to copy forward text fields. I thought I...

Perfect! That works. I just did not know how to code it without using a macro and it worked on the main form. Thank You so much!!!!

I tried the above and it did not work. I have attached my DB I have messed something up. I have 2 macros that work off of the buttons on the main form. the Guest button puts Guest in the Customer name. The Fries button should put Fries in the first record of the subform. If I put the button...

Here is my latest try Forms!frmTicket!frmTicketDetails.Form!FoodID still wrong. I have looked at that web site in an earlier post many times and I just do not get it. my subform name and source object are the same name. Forms!Mainform!SourceObjectname.Form!ControlNameonsubform What am I...

Ok, I thanked you for clarifying the Source Object problem. I am using the right name.

I guess I do not know how to find the name of the control. I am missing something important obviously. When I look at the main form in design view I do not know where to find the name of the control. Sorry to be so clueless.

I have a main form frmTicket and a subform on the above form named frmTicketDetails I am trying to setProperty in the subform on control FoodID Please correct my mistakes none of these work Form.frmTicket.frmTicketDetails.Form.FoodID Form!frmTicket!frmTicketDetails.form.FoodID...

I created a button and the on click is set to SetProperty ControlName Helper Property Value Value Bob I need to add something that changes focus to next record but everything I have tried gives me an error. This is in a subform so when I use goto new record or next...

Hi, I created a macro on a subform that does setProperty value to Bob in the helper field. Works for first record in subform. I only have 3 helpers Bob, Susan and Sam so I created 3 macros for each value. So I created 3 macros they work fine. The problem is how do I make them move to new...

I added the buttons I am trying to get to work. The $5.00 button I want to change the PaperMoney field to 5 The Fries button I want to New record and change the FoodID field to 1 The Pie button should New record and change the FoodID field to 2 The Pop button should New record and change the...

I deleted the code that did not work. I will add it back and upload again

The patient login is cool. I clicked the Thanks button.