Search results

Just FYI, you actually can have a continuous main form with a continuous sub form, you just need to place them both on another blank form and use a hidden text box to link them. Not saying you necessarily need to redesign what you have now, just letting you know it's possible. With your current...

Before you begin to get involved in form/report design, I would suggest you rethink this table design. This is going to continually cause problems when you try to design/implement other aspects of your application in the future. If you go to this page you will find some good information on this...

The code to create multiple QR codes is already there. Look at the most recent file that June replaced in post #30. There is a button named Mutiple QRCode that will loop through Table1 and create a QR code image for each record.

@Colin I tested using Windows 7 and A2010. It works and accurately gets my current location (in Denver, CO, USA). I also tested moving the accdb and the html file to a different folder from where I originally saved it and it still works. I am not experiencing the same error you are when...

What worked? There were two different solutions offered. It may be helpful to future readers of this thread to know which one worked.

When you say "It returned...", what do you mean by It? What did you try?

It could be that [Value 2] is not actually Null, but rather an empty (zero length) string. Try; IIf(Nz([Value 2], "")="","",[,sw_] & [Label 2] & [=1] & [Value 2]) On a side note, you should consider removing special characters and spaces from your field names if possible. It just causes...

What is the structure of the underlying table(s)? Do you actually have fields like; Merchant, Merchant 2, Merchant 3 First Name 1, First Name 2, First Name 3 etc.?

Just saw June7 beat me to the punch. The result of June7's code would be slightly different than mine, but may be better if you are trying to import/modify the data in Access because it keeps it more normalized. Depends on what you're really trying to do I suppose.

I wasn't clear if you are trying to do this within Access or Excel, and the results you want are a bit out of the ordinary (I can see what you're trying to do, it's just unusual), so I just coded this in Excel. I added a button to your first worksheet (look at the code for the button). Column F...

Not if your code is looking for files that were last modified within the last second; If FSO.GetExtensionName(fsoFile) = "txt" And DateDiff("s", FSO.GetFile(fsoFile).DateLastModified, Now()) < 1 Then

You may find this thread helpful.

Yes, you can do that.

Something like the following (air code); Dim appXL As Excel.Application Dim wks As Excel.Workbook Set appXL = CreateObject("Excel.Application") Set wks = appXL.Workbooks.Open("C:\Users\SomeUser\Documents\YourExcelFile.xlsx") appXL.Visible = True With wks...

First, I agree with JDraw in terms of table level Data Macros. They really have limited use cases. They were introduced (I believe) as part of M$oft's misguided attempt at Access Web Apps, and have stuck around even after the web app debacle has been abandoned. You're better off using VBA for...

I have reattached your sample db. I modified your data macro and added an Update query (Query1) for tblRoster. If you change the criteria for the update query and run it you'll see that the Notes field in jnctblPositionNumber changes and shows the old value of TCode in tblRoster. No idea if this...

@ Southhaven If you're going to crosspost, please mention that you have done so, so that the volunteer responders in the forums are aware and can check if an answer has already been provided in another forum before they spend time and effort on a solution to your problem.

Crossposted at http://www.accessforums.net/showthread.php?t=71616

Wait......what? You mean to tell me that won't automatically trap for my beverage handling errors? All these years, operating under false pretenses. Now what? Back to square one I guess. Maybe Allen Browne has a solution on his site ;)

Open the properties for the label, go to the Other tab, under Controltip Text put your message.