Search results

Is it possible with CBO to reference a report or a form with something like the following? .TextBody = "customerComics" Currently I am attaching my report as an attachment but I would prefer to have it in the actual email instead. I'm using runtime access. I was also having problems adding a...

When using runtime access (tried 2013 and 2016) I am getting an "SendObject isn't available right now" error. I have no problems with it when using the full version of Access. I'm using thunderbird. Maybe there is another code I can use or a way to get it to work? Some forums suggested...

I'm getting a compile error. I was trying to use ShellToFile for links in a table. Is there another way that allows users to click links that are part of a list? Some items in the list have a link, others do not. They are different links. I was using this code: Private Sub cmdOpen_Click()...

More ways to debug compile errors? Having problems creating an accde file Trying to follow the directions "Correct any problems in the code that prevent you from compiling the database or project" from microsoft to no avail I added Sub Generate_Compile_Error() MsgBoxx "This will cause an error"...

Is it possible to make a database unique to the computer it is on so it cannot be shared? I was thinking I could use the machineid I tried to follow the directions on the thread below but I'm having problems getting it to work and also once it's activated, users could just copy the file? I was...

I'm getting an error that says my query is corrupt. I've dumbed it down to this: UPDATE [tcg CSV] SET [tcg CSV].[My Price] = 10 Where ([tcg CSV].[My Price] Is Null); Whereas this works fine: UPDATE [tcg CSV] SET [tcg CSV].[My Price] = 10; Not sure why, been using this query for awhile now...

I have a datasheet that is filtered when you click any of a few buttons I use browseTo. A few of the buttons will show the quick filter list. The code for the browseTo is all the same except for the where condition field. The buttons with these codes does not show a drop down list when I try...

This worked before, not sure why it is no longer working Here is my query INSERT INTO [add to list] ( Series2, Publisher, comic, Qty, special ) SELECT [diamond order].Series, [diamond order].Publisher, [diamond order].comic, [diamond order].Qty, [special subs new].special FROM [special subs...

Trying to calculate the hours my employees have worked. The table format I'm using can't be altered, its created by our pos program. For example I have fldUserID fldTime fldType fldDate blake 12:04:38 PM Begin Shift 6/3/2018 blake 6:31:44 PM End Shift 6/3/2018 sam 9:22:06 AM...

Considering getting a sharepoint account, but I would like to make it so customers can login with a password to access their data. How would I do that in a web app? My database could be as simple as list of comics, list of customers and list of subscriptions (who is subscribed to what). But it's...

Hello, I have a database that I would like to put online most likely using sharepoint? It's a list of comic subscriptions, I'd like for our customers to see what they are subscribed to, possibly make changes. It's a pretty simple database, at least the part that I would upload. However...

Is is possible to use a combo box but not show the drop down? I've disabled it so it isnt possible to change, but I would prefer it to appear like a regular text box. The combo box has two columns, ID and name, it auto selects the ID when loading and shows the user the name. Unless that's...

I have a query that takes a text field and removes "#" leaving just a number Number:Right([issue],Len([issue])-1) Then I made another query trying to use the max total of this number, it works except for it is returning 8 as a max instead of 10. It's not seeing 8 as 08. It seems like it is...

I'm getting the error: expression is typed incorrectly or it is too complex Basically I want to truncate before either a " #", " annual", or " tp" series1: Left([comic],IIf(InStr(1,[comic]," #")=0,Len([comic])+1,InStr(1,[comic]," #"))-1) series2: Left([series1],IIf(InStr(1,[series1],"...

I have 3 tables, one for customers, one for comics, one for subscriptions. Is there a way to make a crosstab query that would show if a customer has an existing subscription or not? The value would I guess need to be created somehow, based on if there is an entry listed in the subscription...

I am trying to combine multiple graphs (about 4) together into one blank report. I have just dragged and dropped a couple of reports into it, it seems to work ok at first, but the last graph is showing up with incorrect data, almost as if I just need to refresh. I've tried closing, reopening...

I am trying to do a loop that alters records as it goes. My tables are setup as Orders->OrderDetails. I have a currency field named ProfitPrice within OrderDetails. Currently I have this working code using macros: pass parameter prmOrderID SetLocalVar varOrderSubTotal = 0 For Each Record IN...

Hello, I am trying to alter a form (OrderDetail) from the Northwind Traders Database. Basically I have made a Detailed Category field and would like to "drill-down" the list of products based on this detailed category So the user would select a Detailed Category, then select a product with that...

Basically what I'd like to do is delete my "old" table, copy my "new" table and rename it "old", then copy "blank new" and rename it to "new". Basically a big switcheroo, so I can enter new data into the blank table and compare with the most recent data. So from what I've read I need to create...

I'm using a modified northwind inventory database I have an order, with order detail line items eg. Order1->product1 $10 ->product2 $20 Using an after update event, I use setProperty to set ProfitPrice equal to ProfitPriceTemp. Most of the time it works, but when the temp value=0.38915...