Search results for query: *

Thanks for the reply. I actually took a different much easier approach but now i'm having a different issue. what i'm doing now is getting the actual delivery days it took, for example, package was picked up on 3/05/09 and it was delivered on 3/09/09 therefore my delivery days should be 2...

thread701-1136806 Hello, I been trying to follow the steps in thread thread701-1136806 to add my fields [P/U day] + [Transit days] while taking into account weekends. I'm however getting a zero as my value. not sure what im doing wrong but here's my Query SELECT [Estimated Delivery...

Hello, I need one of my cells to put a date stamp on that row every time a value is entered. Example every time a value is entered in cell D14, Cell AF14 will automatically put today’s date and keep that date forever. I tried the following formula =IF (D14,TODAy(),"") but every time I open my...

I already have the values concatenated, but now i want to print a barcode that is going to bring up those records when i scan the barcode

is there any way i can create a barcode from fields in a datase?

How can i calculate the difference between time in excel? Exm Start Time End Time # of Seconds # of Minutes 9:00 18:18 558 9:18 I want the formula to tell me the # of seconds and number of minutes. Thanks JG

How do I run queries from another database? or maybe there is a better way to do this. here's what i am trying to do. I have one database that uses data from 18 databases, I need to run a querie which updates the data in each of this 18 databases. I would like to create a command that would...

I'm getting a #Error thanks

Hello, I have the following IIF statement but i keep getting an #error. any ideas what i am doing wrong? Thanks JG REC: IIf([adj]>=[trigger],&quot;YES&quot;,IIf([adj]<[trigger],&quot;NO&quot;)) I even tried this and still keep getting an error. REC2...

I started to run the code like this and its working perfectly Private Sub Command36_Click() Set db = CurrentDb db.QueryDefs(&quot;x1a - random pick slots&quot;).SQL = &quot;SELECT TOP &quot; & RandomPrompt() & _ &quot; * FROM [X1A Pick Slots] &quot; & _ &quot;ORDER BY Rnd(asc([slot]));&quot...

I tried putting the code in the form, when i click on the button i get a error meassage that tells me &quot;compile error, user defined type not defined&quot; and then it highlights &quot;Private sub command0_Click ()&quot; in yellow and it also highlights &quot;db As DAO.Database&quot; in blue...

Scriverb, Thanks for your reply! I'm not that familiar with VB but i been trying to run the code above but can't really figure out how to do it. do i have to make 2 different modules, or just 1? again.. i apologize for my ignorance but any help would be truly appreciated. thanks

Hello, I currently have a query that randomly selects 100 records from a table. My SQL statement looks like this: SELECT TOP 100 * FROM [X1A Pick Slots] ORDER BY Rnd(asc([slot])); I'm trying to change my statement so that i can enter the number of records i want to select every time i run...

I have a query that randomly selects 87 records from a table, is there a way that every time i run this query those 87 records are deleted from the original table so they can't be selected again??? Please Help!!! Thanks